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 ('5870212')
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 ('5870212')
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.
N1999YToth Thomas I · Federal Way, WAN1LLC&L West Coast Flyers LLC · Dixon, CAN201DYDrenner Scott · Mount Pleasant, WIN201MNWeidner Jamie A · Perrysburg, OHN203PWWood Philip A · Stamford, CTN206HTPepke Mark E · Memphis, TNN20EHUnzicker Keith R · Benson, ILN20TUClark Steven · Dade City, FLN20VMHaney Kieron J · Irrigon, ORN210WDShillieto Gordon W · Burlington Flats, NYN211LKPerry Phil Michael · Vero Beach, FLN2138RWisdom Victor · Sterling, CON214SHSiu Ena · Reno, NVN21776Beebe Jerry D · Cassville, MON21DDHam Arthur J · Gun Barrel City, TXN221YDMcafee Michael D · Chandler, AZN222SPRobinson Avery Clark · Phoenix, AZN22FHPapasavas Paul A · West Orange, NJN23575Registered aircraftN245DAReyes Carlos E · San Juan, PRN246JMForbes Thomas L · Poland, OHN2552WNahas Rafik E · Laguna Niguel, CAN2554WThomas Ryan · Carolina Beach, NCN2557WAndre Norman C · Downers Grove, ILN2560WManasseh Medical Imaging Inc · Lubbock, TXN2561WStaker Bryan P · Pleasanton, CAN2569WDenenny Richard H · Spokane Valley, WAN2576WKepler Anthony · Newberg, ORN2580WLewis Kyle Walker · Trenton, TXN2581WClay Shelli V · Savannah, GAN2585WClassic Mooney Nv LLC · Henderson, NVN2586WVizinat David C · Ragley, LAN2589WHart Christian L · Highland Village, TXN2590WWheeler James N · Shreveport, LAN2594WMcclure Richard A · Victoria, TXN2595WReid Lois M · Dallas, TXN2598WSunset Aviation LLC · New Iberia, LAN2599WBinger Thomas C · Stillwater, MNN2602WHartman William J · Yuba City, CAN2603WMorrey Joseph T · Erie, CON2604WIghzawi Saif F · Green Bay, WIN2607WPlumb Russell V · Apple Valley, CAN2613WAnderson Raymond O · Bismarck, NDN2616WDenney David W · Fowler, CON2619WSmith Cecil · Fort Pierce, FLN2624WWilkins James K · Owens Cross Roads, ALN2625WPatton William D · Sheridan, WYN2629WHogan James C DBA · Cameron Park, CAN2634WGuerrero Aircraft LLC · Newport, WAN2635WElam Brent R · Woodford, VA
Back to Mooney M20E