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.
N2153KCaf Design LLC · Wilmington, DEN2155ECavu Aviation LLC · Sugar Grove, ILN2155KCurrent Obsession LLC · Gaylord, MIN2157LAviation Medical Solutions Pllc · Mesa, AZN2158N2th Aviation LLC · Johnson City, TNN2159ER & S Investment Partners LLC · Kennesaw, GAN2161SRegistration Pending · Montezuma, NMRegistration pendingN21625Simpson Aaron J · Fort Smith, ARN2164KSamojen Tony J · Camarillo, CAN216RAK&E Equipment LLC · Hammond, LAN21786Affinity Insurance Partners Inc DBA · Clearwater, FLN2182HSpangler & Pion LLC · Davis, CAN2183ALee Christopher M · Port Jervis, NYN21843Robertson James D Trutee · Mountain View, CAN2192JMcguire Robert · Hawthorne, FLN2197HGprr Inc · Downers Grove, ILN21KUAero Eagle One LLC · Kerrville, TXN21MSVan Hanna Flying Circus LLC · Castle Rock, CON2204LMccann Richard H · Shuqualak, MSN2209MGarner Aviation LLC · Tampa, FLFirst renewal noticeN2210YN2210y LLC · San Antonio, TXN22166Reading Jared T · Uvalde, TXN22184Rosene Richard W · Newport, RIN221VArea 52 Holdings Inc · Darlington, SCN2220NDushek Matthew S · West Hartford, CTN2228DAircraft Guaranty Corp Trustee · Oklahoma City, OKN2228KSouthern Aircraft Consultancy Inc Trustee · Casper, WYN2229FMulligan Aviation LLC · Janesville, WIN222GXBorchert Ronald L · Richfield, OHN222JFCline Denis Jay Trustee · Colton, CAN222VSCharlie Rogers Ford Inc · Dayton, TNN234WSMancini Gary Ray · Livermore, CAN241SGFalasco Joseph R · Little Rock, ARN242MDSpyder Flights LLC · Manchester, PAN246PCLna Flyer LLC · West Palm Beach, FLN249SAGribble Ted A · Paris, TXN251PCarolina Real Estate Consultants LLC · Pickens, SCN252MASbkb Aviation LLC · Henderson, NVN261JMHundal Medical Corp · Malibu, CAN26FFFastfun LLC · Fort Myers, FLN276CMTwo Fly Guys LLC · Orlando, FLN278DBCt42 LLC · New York, NYN2811AAdrien Aviation LLC · Rochester, MIN288DMDavidson Christian · Auburn, WAN299AGSky West Aviation Inc Trustee · Albuquerque, NMN299LG2 Huskies LLC · Sheridan, WYN29EMIngram Earl · San Marcos, TXN2ALAl Corporation · Wilmington, DEN2SAInternational Air Services Inc Trustee · Carson City, NVN300MESjk Aviation LLC · Orland Park, IL
Back to Mooney M20R