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.
N6947NFlyfaraway Partners LLC · Sparta, NJN6948NPeck Jeff · Denton, TXN6954VGrubb Jefferson D · Chesapeake, VAN6956VAbney Timothy R · Crossett, ARN6957VKnoke Keith W · Litchfield Park, AZN6958UVauclin Brady P · Shreveport, LAN6958VSale Reported · Austin, TXSale reportedN6960UWayne Brett M · Saint George, UTN6961UMeservey Harley G · Portland, ORN6962UGrey Scott A · Bluff City, TNN6980VTenney Kenneth Lee Jr · Princeton, KYN6994URegistered aircraftN6996UHanrahan William P · Seward, AKN6997UDoull Leyla · Miami, FLN6999DN6999d LLC · Fairfax, VAN6999URuff Daniel D · Yacolt, WAN7022VCjsm LLC · Winter Haven, FLN7023VJackson William G · Clinton, MDN7044VMcardle Lesa · Lincoln, CAN7045VMooney N7045v LLC · Windsor, CON7048VProsum Ventures Inc · Mckinney, TXN7070VCraven Bradley A · Logansport, INN7073VOwen Greg · Ukiah, CAN7074VRoyal J · Arlington, TXN7087VRanger Aviation LLC · Memphis, TNN7089VFitts James M · San Antonio, TXN7091VFreimund Chandler R · Big Horn, WYN7092VTextor William E · Springfield, MON70GBVinter Mooney LLC · Philadelphia, PAN70TPhillips Fire Design LLC · Colorado Springs, CON7100UTeerlink Randall Spencer · Hanover, VAN7101UJucha Raymond A · Mount Dora, FLN7101VEquus All American LLC · Midwest City, OKN7103VLennartson Gerald J · Greensboro, NCN7104VPorzillo Patrick H · Newburg, MDN7105UMolter Roy G · Shelbyville, INN7106UTappon Wayne A · Ladysmith, WIN7107UJohnson Kenneth D · Camdenton, MON7109UOyler Joseph B · Kokomo, INN7116VPeterson Robert E · Mobile, ALN7117VNrv Flyers Inc · Blacksburg, VAN711DFFly Mooney LLC · Phoenix, AZN711LPJohnson Tommy A · Grand Junction, CON7123UMatherly Frank · Greenbrier, TNN7132VCrowley Preston R · Northport, ALN7133VKing Mitchell Earl · Columbus, MSN7135VHerkoltz Patrick Alan · Phelan, CAN713JPArizona Technical Construction LLC · Lake Havasu City, AZN7151VDakota Ear Nose & Throat Clinic Pc · Green Bay, WIN7153VTamadon Farhad F · Chino Hills, CA
Back to Mooney M20C