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.
N252PBNicholson Bob · Atascadero, CAN252PLOchoa Preston J · Lemoore, CAN252PRFlying Falcon Pllc · Hailey, IDN252QJimmy Takes Flight LLC · Lake Havasu City, AZN252QMHayden John P · Felton, DEN252RDRobert A Davis Cpa Inc · Fresno, CAN252RHCordes Gregory R Trustee · Morro Bay, CAN252RKRegistered aircraftN252RMGolden Arrow Aviation Inc · Wilmington, DEN252RSHoover Bradley Eugene · Port Townsend, WAN252SDAgostin Rick · Louisville, KYN252SJReiner Robert D · Santa Fe, NMN252TBSkyview Global LLC · Auburn, CAN252TCPeterson Aron F · Carterville, ILN252TDWhite Kurt · Amarillo, TXN252TGTodd Gordon Enterprises LLC · Mooresville, NCN252TMThakrar Praymal · Houston, TXN252VARiverside Exteriors Inc · Kalispell, MTN252VLJagerfly Ltd · Norwalk, CTN252VMCarraway Terry F Jr · Aberdeen, MDN252VVEdgar Clinton Wayne · Douglass, TXN252WDNegawnee Enterprises Inc · Tucson, AZN252WGMelville Flyers Inc · Wilmington, DEN252WSPlane Fun Inc Tr Trustee · Snellville, GAN252WTB&E Aviation LLC · Exton, PAN252XMRegistered aircraftN252YBKetcham David J Trustee · Oceanside, CAN252YCTech Now LLC · New York, NYN252YEMayaire Inc. · Rochester, MNN252YFDowd Arthur D Jr · Stoughton, MAN252YHHenry Thomas J · Fort Worth, TXN252YLShifrin Matthew David · San Antonio, TXN252YNMighty Mite Industries Inc · Gresham, ORN252YPBelle Grove Aero LLC · Dothan, ALN252YQ252yq LLC · Naples, FLN252YRSeedair Inc · Boca Raton, FLN252YUSchmitt David E · Charlottesville, VAN252YYFrazee Brian D · Horseshoe Bay, TXN252YZSchwartz David J · Social Circle, GAN252ZAMvs Air LLC · Reddick, FLN252ZCRegistration Pending · Sheridan, WYRegistration pendingN252ZEFlorida Flying Tigers LLC · Brandon, FLN255JWDillon William M · Dayton, NVN257KWPridgen Aaron Wade · Pebble Beach, CAN261CBGober Charles K · Sand Springs, OKN261DBKhamer Laasn LLC · Longmont, CON261LABrown Jeffrey L · Mint Hill, NCN261RTjarks Edward F · Mesa, AZN261RJJaycobs Richard · Siasconset, MAN261TAMiller Shawn M · Canovanas, PR
Back to Mooney M20K