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 ('5870220')
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 ('5870220')
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.
N5254GPressley Brent DBA · Morristown, TNN5265PRaetech Motorsports Inc · Ann Arbor, MIN5267WMooneyshine LLC · Delafield, WIN5269RCharles Hamptons A-1 Signs Inc · Dickson, TNN526EOn Target Ammunition LLC · Grain Valley, MON5285TRoberson Michael W · Cornelia, GAN5289DOgrady Gerald P Trustee · Soquel, CAN52938Fermata Aero Inc · Milwaukee, WIN5293RDelissa Leighton A · Meade, KSN52EMDahl Dale Shannon · Prineville, ORN52RJVirtue Gary A · Eastchester, NYN533WMSunrise Water Co · Sunrise Beach, MON55PEVenusti James J · Mahwah, NJN5612WNelson Kenneth G · Holly Ridge, NCN5614JAltair Aircraft LLC · Gainesville, FLN5620ZCloudtop LLC · Rockport, INN5634NWismer Mark C · Britton, SDN56354Bas Part Sales LLC · Greeley, CON5635CGotham Brooks · Schaumburg, ILN5639DDettinger Paul N · Hudson Oaks, TXN56411Hunter Aire Inc · Lumberton, NJN56438Gamble Ross A · Copperopolis, CAN56441Seaward Yachts Inc · Palm City, FLN5659CBeck Gary F · Cypress, CAN5659LKool Wings Leasing LLC · Indianapolis, INN5659MWorldquest Enterprises LLC · Phoenix, AZN56634J&R Enterprises LLC · Wichita, KSN5664BPohl Raymond F · Englewood, CON567JNFay Jack R · Port Charlotte, FLN56829Hill Jonathan D · Miramar Beach, FLN5692XAop Aviation LLC · Marlborough, NHN5699YMullock Richard · Sacramento, CAN56GDLane Theodore T III · Garden Ridge, TXN57032Fly The Whites LLC · Wolfeboro, NHN5703YHoward Tony L · Punta Gorda, FLN57055Home Free Aviation LLC · Ridge, NYN57090Foley William J · East Lansing, MIN57097Mcenrube Inc · Fort Collins, CON57142Wilson John R · El Dorado Hills, CAN57146Rocket 57 LLC · Scottsdale, AZN57195Self Levi · Peculiar, MON57220252sm Big Sky LLC · Kalispell, MTN57227Zingaretti Gabriele · Felton, CAN57229Rose James M · Daphne, ALN57232Grand Mesa Holdings LLC · Bay City, TXN57241Bas Part Sales LLC · Greeley, CON5726PGreco Edward C · Bend, ORN5737MWehmeyer Rodney · Boerne, TXN57403Pritchard Steven R · Eureka, CAN5741SCrane Steven R · South Colby, WA
Back to Mooney M20K