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.
N261TGCirrus Digital LLC · Asheville, NCN262AKKempton Alan R · Lutz, FLN262BBFive Four November Inc · Littleton, CON262CMyers Thomas · Hot Springs, ARN262EZN262ez LLC · Canton, OHN262JKPeachtree Aviation Inc · Woodstock, GAN262MBMurray Adventures LLC · Dallas, TXN262RVT & J Air LLC · Wilmington, DEN262RWMakino Kazuya · Fountain Valley, CAN262VFBaker Geoffrey D · Philomath, ORN262WDWyoming Development LLC · Cheyenne, WYN262WEN262we LLC · Akron, OHN263DBZulu Murphy LLC · Oklahoma City, OKN268ACPafford David A · Floydada, TXN277TAAndersen Thomas E · Pleasant Valley, CTN27ABSailaway Management Inc · Wilmington, DEN27LPPlane Fun Inc Tr Trustee · Snellville, GAN281RMHolthaus Craig J · Canton, ILN2BLInternational Air Services Inc Trustee · Carson City, NVN2FRMarcum Alan M · Palo Alto, CAN303FWWoodruff Peter M · Kalamazoo, MIN304MADodson International Parts Inc · Rantoul, KSN305BKRegistration Pending · Delta, OHRegistration pendingN305BZFreedom Air Aviation LLC · Broomfield, CON305EEStarfleet Spacecraft Management LLC · Schaumburg, ILN305EPPickard Erik · Deer Park, TXN305GTomahawk Aviation LLC · Reno, NVN305GDGlyn Dwr Air LLC · Kalispell, MTN305GGChayes Daniel A · Mercersburg, PAN305HStat Care Clinics LLC · Baton Rouge, LAN305JBKoning Ryan W · Williams, AZN305JCAccurate Aero LLC · Minden, NVN305JKOrcutt John Edward · Tucson, AZN305JTWinniwolfe Holdings LLC · Wolfeboro, NHN305KFlorida Flying Tigers LLC · Tampa, FLN305KMKeim Jeffrey R · Moorhead, MNN305L305l Air Holdings LLC · Phoenix, AZN305LSHill Karin V · Georgetown, TXN305LWProfessional Flyers Corp · Wilmington, DEN305MHartley John · Kissimmee, FLN305MKCoughlin Enterprises Inc · Central Point, ORN305NHRoesch John M · Largo, FLN305PE305pe LLC · Lakewood Ranch, FLN305PFSale Reported · Crystal, MNSale reportedN305PJBradley Alana J · Joliet, ILN305PRGlahn Guy R · Redmond, ORN305REasterling William D · Salisbury, NCN305RDSouthern Aircraft Consultancy Inc Trustee · Casper, WYN305RKRegistration Pending · Gilbert, AZRegistration pendingN305RMPuglielli Jeffrey W · Bolingbrook, IL
Back to Mooney M20K