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 ('5870208')
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 ('5870208')
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.
N78865Gingras Carl A · Avondale, CON78869Zullo Thomas L · Lindenhurst, NYN7886VLowenhaupt Michael J · Metairie, LAN78871Rosenfeld Kristina M · Eureka, CAN78873Mesner Steven M · Tomah, WIN78874Rabe Robert Michael · Elk Grove, CAN78875Janssen Christopher R · Ankeny, IAN78880Coma Aviation LLC · Buckhannon, WVN78882Triplat Bonnie E · Rosamond, CAN78884Cooke Daniel S · Kanarraville, UTN78888Woodard Ben C · Truckee, CAN78890Edmondson Donald M · Harvest, ALN78891Registered aircraftN78892Rathbun Robert E · Maywood, MON78893King Eugene A · Rch Palos Vrd, CAN78894Gonzalez Francisco C · Biloxi, MSN78897Knox Phillip A · Snellville, GAN78898Clawson Michael · Allentown, NJN7889PWalker Zachary R · Burlington, NDN7889VPoorman Christopher · Burleson, TXN7890VDoherty Kevin R · Silver Spring, MDN78911Watt Charles D · Marietta, OHN78912Mid America Plumbing LLC · Moscow, TNN78913Ambrose Gary L · Camden, NCN78914Collins Camden B · Millersport, OHN78915Hendryx Alec B · Coffeyville, KSN78918Pearlman Fredric M · Southfield, MIN78920Duncan Mark T · Orange Grove, TXN78923Rodriguez Julian P · New York, NYN78925Sale Reported · Winthrop, MESale reportedN78927Sly David P · Nevada, IAN78928Lejcar Matthew J · Cumberland Furnace, TNN7892VLambert Mathew Chase · Chapel Hill, TNN78930Klingenberg Richard A · Idaho Falls, IDN78934Harville Leonard W · Giddings, TXN78936Napier James C · San Diego, CAN78937Reisen LLC · Stevensville, MTN7893VDarnell Noah Alexander · Searcy, ARN78940Gaskins Gregory G · Godley, TXN78943Tutino John · Pleasant Valley, NYN78945Ag-Aero Services LLC · Spring Hill, FLN78946Terra Magic LLC · St Anthony, IDN78949Tour Talent LLC · Akron, OHFirst renewal noticeN7894VHydock David B · Leslie, ARN78953Holman Richard S · Clearmont, MON78955Stuber Paul A · Kansas City, MON78956Pauly Traviston · Natrona Heights, PAN78959Nelson Brian · Pennsburg, PAN78960Lydon Ethan J · Lumberton, NJN78961Schuster Christopher J · Sherman, TX
Back to Mooney M20C