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.
N7740MMason Graham E · Olympia, WAN7742MGribble Ted · Paris, TXN7748MLarson David · Klamath Falls, ORN7751MM&M Aircraft LLC · Arnold, MON7763MZimmerman Kurt L · Blacksburg, VAN7764MEifert Steven W · Clarksville, TNN7765MProgressive Medical Applications Corp · Allentown, PAN7775MDennis Bruce · Rapid City, MIN7778BPeters Ben C · Leavenworth, WAN777LH7 Moon LLC · Albuquerque, NMN7788MMcreynolds Michael A · Sikeston, MON7788VMaltenfort Andrew J · Culpeper, VAN7789MRipato Peter A · Maysville, KYN7802VKruger Matthew J · San Francisco, CAN7803VArtlip James · Wake Forest, NCN7804VVickers David Dewayne · Douglas, GAN7806VMouriz Javier · Leesburg, FLN7807VMad Dog Aviation LLC · Minot, NDN7808VWalker Trenton A · Pittsburg, OKN7811VRivard Jayme · Monterey, CAN7812VStorrud Jerrel T · Corvallis, MTN7814VBewley Terry V · Longview, TXN7815VApice James M · Port Orange, FLN7816VBrown Timmy L · Poplar Bluff, MON7817VWilliams Donald B · Wingate, NCN7820VHarris Colby L · Yellville, ARN7822VBarry John J · Bethel, CTN7832VBaker Benjamin D · Catasauqua, PAN7834VMorris Tommy R · Houston, TXN7837MDiamond B Farm Inc · Gamaliel, KYN7838VLownes Carpentry Contracting · Freehold, NJN7846VPan Mi LLC · Toa Baja, PRN7848VGreen Donald W · Las Vegas, NVN7849VOkaeronut LLC · Ponca City, OKN7851VJensen Jared E · Preston, IDN7852VCobb Brian P · Tucson, AZN7855VRyan Willam R · Jupiter, FLN7856VLampkin Derrick J · Bethesda, MDN7865VGalmor Bobby Don · Shamrock, TXN7868VFagan Lawrence G Jr · Hudson Oaks, TXN7869VEagle Sky Patrol Inc · Deadwood, SDN7870VWilliams Danny L · Carson, CAN7871VEdwards Eddie E · Borger, TXN7872VMac Residential Services LLC · Gravette, ARN7874VHague Collin J · Newark, DEN7875VSmokovitz Daniel J · Brighton, MIN7876VMooneyes LLC · White Oak, TXN7878V7878 Victor Inc · Tampa, FLN7882VSlepian Isaac J · El Dorado Hills, CAN7883VFranks Gary E · Ponder, TX
Back to Mooney M20C