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 ('2072439', '2072442')
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 ('2072439', '2072442')
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.
N9101RMiddle Village Enterprises LLC · Maspeth, NYN910AAWest Michigan Aviation Academy · Grand Rapids, MIN910CPCivil Air Patrol Inc · Maxwell Afb, ALN910SEBates Jonathan R · Chatsworth, CAN912AZN912az LLC · Miami, FLN912JRN912jr LLC · Dover, DEN912LBArizona Flyers Club Inc · Tucson, AZN913CPCivil Air Patrol Inc · Maxwell Afb, ALN914SWSilver Express Co DBA · Miami, FLN915CPCivil Air Patrol Inc · Maxwell Afb, ALN915DDWest Michigan Aviation Academy · Grand Rapids, MIN915TAAurora Aircraft LLC · Waterford, MIN9161TMenagerie Enterprises Inc DBA · Denison, TXN916BAMaya Aircraft Holdings LLC · Lee, NHN916MABusch Brett · Stanford, MTN917CPCivil Air Patrol Inc · Maxwell Afb, ALN917MAKs Flying Club Inc · Manhattan, KSN9181PNorthwestern Michigan College · Traverse City, MIN918CPCivil Air Patrol Inc · Maxwell Afb, ALN919CPCivil Air Patrol Inc · Maxwell Afb, ALN919TCD & S Aviation LLC · Spring, TXN91PFSkyline Solutions Inc · Deland, FLN920CPCivil Air Patrol Inc · Maxwell Afb, ALN920MTAcron Aviation Academy Inc · Sanford, FLN920WBJet Air Inc · Iowa City, IAN921EZAircraft Guaranty Corp Trustee · Oklahoma City, OKN92228Dhs Operations LLC · Wilmington, DEN9222HDhs Operations LLC · Wilmington, DEN9223CDhs Operations LLC · Wilmington, DEN9223EDhs Operations LLC · Wilmington, DEN9223XDhs Operations LLC · Wilmington, DEN92264Dhs Operations LLC · Wilmington, DEN92266Dhs Operations LLC · Wilmington, DEN922CPCivil Air Patrol · Maxwell Afb, ALN9230YDhs Operations LLC · Wilmington, DEN923CTBragdon Emil · Fort Worth, TXN923EDJust Plane Stuff Inc · Jackson, MSN923GWCape Island Aviation LLC · Millville, NJN924CPCivil Air Patrol · Maxwell Afb, ALN924LPEastern Cincinnati Aviation Inc · Batavia, OHN9250VFlight Trainer LLC · Wilmington, DEN9254CFlight Trainer LLC · Wilmington, DEN9254YFlorida Memorial University Inc · Miami Gardens, FLN925CPCivil Air Patrol · Maxwell Afb, ALN925YZFranchetti Kevin · Manchester, MEN926CPCivil Air Patrol · Maxwell Afb, ALN926JAMustang Sally Aviation LLC · Camden, SCN926NLRemington Robert J · Sheboygan Falls, WIN927AZN927az LLC · Miami, FLN927CPCivil Air Patrol · Maxwell Afb, AL
Back to Cessna 172S