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.
N431MJFlightera LLC · Richmond, KYN436PSKramer James E · Nashville, TNN439SFCarter Randy C · Poway, CAN43FMBaseline Digital Inc · Satellite Beach, FLN43HWPiper Nicholas W · Nanjemoy, MDN444ECOvation LLC · Wichita, KSN444HKChurch David H · Albuquerque, NMN446PCStatius-Muller Robert C Trustee · Stamford, CTN44PZRegistered aircraftN451USGreen Llp · Newport Beach, CAN452PSScuffletown LLC · Highlands, NJN453MFSpain William D Jr · Mahopac, NYN4545BTwist Air Inc · Overland Park, KSN456GXBruschi Dale Alan · Hollywood, FLN456PSGaston Trevino Jr · Brownsville, TXN457DKMiller Gordon J Jr · Monaca, PAN4654MJetway LLC · Dover, DEN467PSNeuwirth Robert · Gillette, WYN468DABulk Transfer LLC · Horseshoe Bay, TXN469MMMm Consulting Services · Fort Smith, ARN46BAArrington Investments Inc · Andrews, SCN46DTEagle Ad-Venture LLC · Universal City, TXN46WBBullen Riley P · Kingman, AZN475RBN475rb LLC · Lexington, KYN486PSMartin Jon R · Rayne, LAN489PSTorme Marvin R · Birmingham, ALN493PSOn Target Aviation LLC · Albuquerque, NMN495CPIris Fliers Inc · Fernandina Beach, FLN496DEHegedus Bruce Alan · Anchorage, AKN499RMSchell Robert W Trustee · Doylestown, PAN505WMAndrew Aircraft Sales LLC · Selmer, TNN50ECPremier Wireless LLC · Kalispell, MTN513CZZiebarth Charles M · Darien, ILN513DRSternhagen Richard · Sweetwater, TNN513ZMBullard Aerospace Corp · Boston, MAN514SGBorland Equipment Leasing LLC · Midland, TXN5151FAoa Capital LLC · Missoula, MTN516EFEckinger Construction Co · Canton, OHN517CBDelaware Aircraft Trust LLC Trustee · New Castle, DEN517PSLuna Volantis II LLC · Lewes, DEN521SGPerfect Landing Aviation LLC · Highlands Ranch, CON523JTAircraft Partner Holdings Inc Trustee · BerlinN527TMCampbell Air Services Inc · Roseville, CAN527WMitchell Grayson · Milledgeville, GAN5285PFrank Investments Inc · Austin, TXN5293BBas Part Sales LLC · Greeley, CON5295MPrough Aviation LLC · Stephenville, TXN52KWFreedom Aviation LLC · Alexander, ARN52TFAs The Crow Flies LLC · Belmont, WIN533LJHazelhurst Inc · Middletown, DE
Back to Mooney M20R