Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('8682000')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('8682000')
ORDER BY n_numberRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N850GXBtm Leasing LLC · Cabot, ARN850HAHughes Aerospace Aviation Services LLC · Wilmington, DEN850HDRussoms Cloud Server LLC · Montgomery, ALN850HPRegistered aircraftN850HRKnox Air LLC · Secaucus, NJN850JB850 Jb LLC · Madison, WIN850JHBgd LLC · Fort Wayne, INN850JWProp It Up LLC · Ponca City, OKN850KAEyefly Consultants LLC · Apalachin, NYN850KDMinka-Air Inc · Wilmington, DEN850KHInnisfree LLC · Bourbonnais, ILN850KJAggie Aviation LLC · Buna, TXN850KKK-T Industries Inc · Sheldon, IAN850KPOak Tree Ventures LLC · Verona, WIN850KTDearing Michael P · Anderson, TXN850LCOales Aviation Inc · Wilmington, DEN850LDAluna Corp Trustee · Wilmington, DEN850LEKey 511 Inc Trustee · Wilmington, DEN850LHLiton Services Inc Trustee · Wilmington, DEN850LLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN850LMMansfield Aviation International LLC · Wilmington, DEN850LTSelby Ryan · Sunriver, ORN850MBMavair LLC · Santa Fe, NMN850MFD'Offay LLC · San Francisco, CAFirst renewal noticeN850MKAviara Leasing LLC · Reston, VAN850MRKsd-7 LLC · Sublimity, ORN850MWHampton Blue LLC · Dover, DEN850MYGreen Doors LLC · Lake Charles, LAN850PARf Aviation LLC · Owensboro, KYN850PCPyramid Aviation LLC · Heber, CAN850PDN850pd LLC · Oklahoma City, OKN850PFNethery Cattle Co LLC · Fort Worth, TXN850PKShelton Aviation II LLC · Apex, NCN850PRCharlie Tango LLC · Rapid City, SDN850PTBank Of Utah Trustee · Salt Lake City, UTN850PWKazakh Kid LLC · Charlottesville, VAN850RBLease Holdings LLC · Henderson, NVN850RLValiair Limited Co Trustee · Casper, WYN850RPWest East Bay Aviation LLC · Weston, MAN850SBMagic Carpet Two LLC · Harwinton, CTN850SCSpur Creek LLC · Savannah, GAN850SFAircraft Guaranty Corp Trustee · Oklahoma City, OKN850SJAviation Trust Company LLC Trustee · Oklahoma City, OKN850TASpencer Jackson Holdings LLC · Denver, CON850TBDelta Ag Aviation LLC · Missoula, MTN850TJJ&M Travels LLC · Baton Rouge, LAN850TPPj Capital LLC · Clearbrook, MNN850TSWestern Farming LLC · Missoula, MTN850TVAd Pilot LLC · Frisco, TXN850TXBlanco Resources LLC · Dover, DE
Back to Socata TBM 700