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.
N22MYLewitzke Holdings LLC · Weston, WIN232MA3mc Aviation LLC · Diboll, TXN235SFScott Air LLC · Munster, INN236EATransportation Air Services LLC · Fair Oaks Ranch, TXN23DEFreespeed850 LLC · Newburgh, NYN23MYJetka LLC · Rapid City, SDN2424XDirect 2 Aviation LLC · Elkhorn, NEN247ADOsprey X LLC · New York, NYN24MY1024aviation LLC · Odessa, TXN258SPAstro Aviation LLC · Birmingham, MIN259GMBlue Wing LLC · Nashville, TNN263CWAir Pard LLC · Baton Rouge, LAN265BNN265bn LLC · Waterloo, NEN268JJMkmac Capital LLC · Dallas, TXN2711EEvjlutz LLC · Benton Harbor, MIN275LHProject Tango Inc Trustee · Wilmington, DEN278MP277wt LLC · Jackson, TNN283BSPioneer Aviation LLC · Crossett, ARN288CCFalcon Aviation LLC · Mccomb, MSN288JBCentral Connecticut Aircraft LLC · Plainville, CTN2PDHighfield Aviation Inc Trustee · Wilmington, DEN300AEColumbia Asset Trust Corp Trustee · Wichita, KSN300AZBka Leasing LLC · Kennett, MON301FJBird One Alliance Inc · Laredo, TXN301MAMichaels Air Service LLC · Oconomowoc, WIN302JGJag2021 Inc Trustee · Wilmington, DEN308WCBaron Aviation Of Indiana LLC · Wolcottville, INN312TTAk Consultants LLC · Newark, DEN31343134sb Champion Aviation LLC · Cherokee, IAN313BPSale Reported · Pelkie, MISale reportedN317WCCambusmoon Inc · Glenview, ILN319TBShuck Holdings LLC · Anderson, SCN31RM599tc LLC · Missoula, MTN320SAEagleeye Aviation Inc · West Harrison, NYN321CWBatte Bennie S · Forest, MSN323MPSjk Navigation LLC · Boston, MAN325TWFremont Management Aviation LLC · Lander, WYN329FDEdm Services Aircraft Leasing LLC · Simi Valley, CAN329MMRuegg Aircraft Holdings LLC · Wilmington, NCN32WZMalibu Aviation LLC · Putnam, CTN333EYHatco Oilfield Supply LLC · Palestine, TXN333TZAerospace Trust Management LLC Trustee · Wilmington, DEN338KCJuliet Papa Kilo LLC · Seven Valleys, PAN351CKBelmar Real Estate Management LLC · New Bedford, MAN3524GGlover Aviation Corp · Wilmington, DEN355PMTallulah Aviation LLC · Wilmington, DEN356FRegistered aircraftN363EAThree Six Three Echo Alpha LLC · Katy, TXN367EAGloair LLC · Sugar Land, TXN371CWLpv Holdings LLC · Carlsbad, CA
Back to Socata TBM 700