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 ('5870227')
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 ('5870227')
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.
N410RRGarrison Concrete Systems LLC · Scottsdale, AZN411JLCrowell Robert J · Rockwall, TXN426WWGolfdoc LLC · Kingman, AZN428CMN428cm LLC · Indianapolis, INN42PJCapital Business Forms Inc · San Bernardino, CANon-citizen corporation, flight hours not reportedN437PAEsa Montana LLC · Helena, MTN4414BYoung Ronald R · Albuquerque, NMN478PSTromp Enterprises LLC · Live Oak, TXN484DMValiair Limited Co Trustee · Casper, WYN490PSPeterson Nathan C · Cordova, TNN4YMBranches Aviation LLC · Lake Oswego, ORN511CZFisher Stephen C · Clarksville, ARN512AGJuliet Leasing Inc · Austin, TXN525VTDsvt Management LLC · Northvale, NJN5611FAdrenaline Airlines LLC · Dallas, TXN562BGFalcon Air LLC · Casper, WYN565PAJim Mardis Aviation LLC · Mount Dora, FLN571LLDavis Thomas B · Greensboro, NCN57NGAir 500 LLC · Bastrop, TXN611MSSamuel Timothy · Kent, WAN618BLOrr Keith M Trustee · Portsmouth, NHN627HPRobinson Elizabeth R · Malibu, CAN632PAN632pa LLC · Debary, FLN633GLRodine Dore N · Las Vegas, NVN654ADTrull Robert Scott · Austin, TXN665AGAircraft Guaranty Corp Trustee · Oklahoma City, OKN669WTLegacy Aviation LLC · Haddon Heights, NJN676JMDpe Services Inc · Des Plaines, ILN688MDDiamond Aero Corp · La Quinta, CAN705SEJones Hugh M · Locust Valley, NYN708BCCc Liaison Corp Trustee · Wilmington, DEN708PJKolasa Mark W · Washington, NCN721EMEuroaviation Inc Trustee · KematenN730MLRomeo Juliet Whiskey LLC · Saint Louis, MON745DLLambert Thomas · Grand Junction, CON772PACassity Scott · Las Vegas, NVN7758JLeaman Gary R · Alpine, WYN781TCKeystone Ridge LLC · Colorado Springs, CON781WBCopley Square Air LLC · Weston, MAN782JBRibaudo Janice · Los Angeles, CAN79333Blue Moon Navigation Inc · Austin, TXN809PAHardy David · Fairview, MTN812PTAngel Ventures LLC · Natchez, MSN815TLee D Trotter Do Pc · Rapid City, SDN872PALima Delta Co Trustee · New Castle, DEN892PSKahoe Timothy P · Charlotte, NCN906TTerry Jack · Ontario, ORN922DHHeichel Air LLC · Corpus Christi, TXN923JMOmega Lake LLC · Wilmington, DEN931ACValiair Ltd Co Trustee · Casper, WY
Back to Mooney M20TN