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.
N711CJTsq Solutions Inc · Sacramento, CAN731CWInternational Air Services Inc Trustee · Carson City, NVN747MRParkset Air Inc · Jupiter, FLN755FMSwenson Karine M · Santa Fe, NMN75PWPapa Whiskey LLC · Darien, CTN765MKMeyers Mark · Santa Rosa Valley, CAN777MTNortheast Cub LLC · Hudson, NYN787SECordes Stefan F · Bethesda, MDN799LMMorehouse John R · Flintstone, GAN800AGAbram Keith · Cedar Hill, TXN80GYInternational Air Services Inc Trustee · Carson City, NVN813JJWash Steven M · Austin, TXN820GLFrank Kevin M · Glenview, ILFirst renewal noticeN824AAMaclennan Donald J · San Jose, CAN824JLSamuels John T II · Winfield, ILN83MFAircraft Guaranty Corp Trustee · Oklahoma City, OKN868PCHoefly Christopher S · Belleview, FLN871AMMorris David · Fort Worth, TXN880RAAerospace Trust Management LLC Trustee · Wilmington, DEN885DLSky West Aviation Inc Trustee · Albuquerque, NMN888BCTwo Hundred Co · OntarioNon-citizen corporation, flight hours not reportedN888HWEvidence Vault Company Inc · Orchard Park, NYN908NTBud E Aero Inc · Franklin Square, NYN91618Mnich William R · Powell, OHN916BLLiang Chen · Houston, TXN916CBOne One Delta Transit LLC · Wilmington, DEN921ZF Michael Schultz LLC · Coleman, TXN922PTPazik Randy · Pahrump, NVN928MBTraveling Pals III LLC · Fort Myers, FLN93722Ridgely Austin · Parkersburg, ILN9384RBas Part Sales LLC · Greeley, CON93FCN93fc LLC · Merino, CON9415UVostretsov Evgeny · Cambridge, MAN94312Seeba Thomas D · Reno, NVN94JBIntegrity Aero LLC · Boerne, TXN9540VCapital Aviation LLC · Bismarck, NDN9542ZD Danger LLC · Allentown, PAN95442Pressley Brent DBA · Morristown, TNN9547UWheels & Wings Inc · Staten Island, NYN9554UMidway Enterprises Inc · Wilmington, DEN95662Schopp Ty P · Hernando, MSN9582UJohnson Daniel L · Menomonie, WIN9590UN9590u LLC · Miami, FLN963PMAranha Jason Piotrowski · Los Angeles, CAN97258Cass Flying Venture Inc · Wilmington, DEN97353Jk Aviation LLC · Batavia, ILN97429Leblanc Scott G · Red Bluff, CAN9759UBrockett Joe · Hubbard, TXN9764SSmith Kenneth W · Bedford, INN9775VRegistered aircraft
Back to Mooney M20K