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 ('5870225')
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 ('5870225')
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.
N108MBBuchinsky Stephanie Lynn · West Plains, MON111DDMoonrad LLC · Republic, MON111VSSite Development Inc · Mount Laurel, NJN111WSM20r LLC · Centennial, CON118MARussell Kenneth · Santa Cruz, CAN11VVSchmidt Milton W · Cincinnati, OHN11YESky West Aviation Inc Trustee · Albuquerque, NMN120GXLow & Slow Aviation Ventures LLC · Fort Myers, FLN121RPJohn A Rossi Inc · West Chester, PAN1234MDelta Mike Aviation LLC · Darien, CTN124ELerro Furey W · Wildwood, NJN124EVEl Aero Services LLC · Verdi, NVN127BSDemaagd Aviation LLC · Hickory Corners, MIN132BGN132bg Corp Trustee · Wilmington, DEN134MCByars John Jr · Houston, ALN142GXDicey Emery B · Port Orange, FLN143ABMisch Keith · Staten Island, NYN143TMSchnautz Danny R · Pasadena, TXN14ACLippert Bradley W · Crawford, CON1525THamilton John D · Frederick, MDN155DSJk Diamond Star LLC · Hillside, ILN15PDHunter Philip · Great Falls, VAN169HWood Wendell · Holland, TXN16RMBbj Aviation LLC · Shelby Township, MIN190DRLehrke Thomas Alan · Bloomington, MNN191KTLobianco John N · Woodmere, NYN192AGBp Aviation LLC · Gilbert, AZN192JKWest Gregory B · Cummings, GAN194VUphoff Jeffrey A · Roanoke, VAN196GXRhodes David · Washington, DCN197DTSzczerba Francis C · Cranberry Township, PAN197RMHjh Aviation LLC · Gordo, ALN199MDSurgair Inc · Absarokee, MTN200VPDrp Aviation LLC · Southlake, TXN204GXAircraft Guaranty Corp Trustee · Oklahoma City, OKN205BFWells David L · Neosho, MON205BZEmbedded Advantage LLC · Chelsea, MIN209HWWep Ent LLC · Graford, TXN211MJKeefer Squared LLC · Rockmart, GAN211TSMartin Rolf Michael · Wellsburg, NYN2120XGolberg Companies Inc · Garfield, MNN2121SGreat Bay Aviation LLC · Spring Hill, FLN2126SGarnet Ridge LLC · Brooksville, FLN212TAJensen Paul · Exeter, NEN2138ZPyle Richard B · El Paso, TXN21434Ad-A-Note LLC · Tarentum, PAN2144PVanderhoof Brian L · Purcellville, VAN2145XMitchell Derrick · Winter Park, FLN214DAFlight International Inc Trustee · Dover, DEN214JSChavez Frederick J · Temecula, CA
Back to Mooney M20R