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.
N6883VHubbell Carl · Crowley, TXN6884NLutes Kent A · Tazewell, TNN6884USheaffer Bruce R Jr · Lititz, PAN6884VVan Dyck Ryan G · Talent, ORN6885NPoskevich Douglas · Deland, FLN6885UGranier Bernie C Trustee · Bandera, TXN6886UN6886u Inc · Tucson, AZN6887NColton Frank Lasusa · Harrisburg, PAN6887UAce Aircraft Leasing Inc · Nazareth, PAN6888NGrass James Conrad · Phoenix, AZN6893URk Management LLC · Garden City, KSN6894UShonrock Clinton O · Los Alamos, NMN6895UWoodward Jeffery F · Viroqua, WIN6896NHarding Ronald D · Spokane, WAN6897UStyer David B · Pendleton, ORN6899NStearns Lloyd Bernard · Georgetown, TXN6899UMayo Clayton E · Ten Mile, TNN69007Jj Kramer Aviation LLC · Vero Beach, FLN6900NBond William E · Elk River, MNN6900URegistered aircraftN6901ULime Lounge LLC · Des Moines, IAN6902NSherrill Charles H · Robert Lee, TXN6903NRoland Jason R · Royse City, TXN6903UPray Aviation Inc · Augusta, KSN6904UMyers Ronnie L DBA · Appling, GAN6905NZero Five November Holding Inc · Kalispell, MTN6905VOscar Mike Appraisal Group LLC · Greenville, SCN6906VMatthews Cheryl L · Baker City, ORN6907VPounds Gregory S · Sykesville, MDN6908UPaul Michael · Fort Worth, TXN6908VForoozesh Paymon Michael · Olalla, WAN6909NDevore John A C · Marion, OHN6909UVandivort Austin J · Strawberry Plains, TNN6917NBonak Steven · Punta Gorda, FLN6919NNicholas Dagmar H · Uniontown, OHN6920CKiesel James L · Hanford, CAN6921NBower Edwin M · Norco, CAN6923NTurner William H · Parkersburg, WVN6926NTurtle Mountain Air LLC · Bottineau, NDN6928NToysformud LLC · Missoula, MTN6928VSky West Aviation Inc Trustee · Albuquerque, NMN6929VHerzog Property Management LLC · Fergus Falls, MNN6930VMatisko Michael J · Newburgh, INN6932VMcilwaine Archibald G · Mc Allister, MTN6935NNordahl Michael · Rancho Cucamonga, CAN6937NRourke William Patrick · Lavonia, GAFirst renewal noticeN693MMAnthony Adderly · Morgan Hill, CAN6941NCaro Carlos H · Mcallen, TXN6943NPhoenix Aviation Holdings LLC · Mesa, AZN6945NEveland Benjamin E · Henderson, NV
Back to Mooney M20C