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 ('5870219')
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 ('5870219')
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.
N40SVBarr Michael B · Houston, TXN40XXRegistered aircraftN41007Registered aircraftN4100HTj Air Holdings Inc Trustee · Wilmington, DEN4102HForeman Guy W · Valparaiso, INN4105HBonanza Valley Air LLC · Alexandria, MNN4110HKoerkenmeier James J · Carlyle, ILN4112HGroves Carl Jr · Lebanon, TNN4113HWettstein Tim · Manhattan Beach, CAN4114HSemeniuk Steven Ty · Houston, TXN4122HBeck Randy R · Claremont, CAN4124HTyler Patrick E · Poplar Grove, ILN4125HOsterbeck Jeffrey A · Jackson, WIN4128HLehnert Jaxon C · Turpin, OKN4138HMiller John A · Ballston Lake, NYN4148HRegistered aircraftN4152HMountain West Aviation LLC · Denver, CON4164HRobertson James I · La Pine, ORN4171HHanson Zane · Danville, INN4182HAir Superiority Inc · Syracuse, NYN4192HBrown Joel M · Kokomo, INN4199HN4199h Club Llp · Oshkosh, WIN4201LSuverkrup Mark · Columbus, INN4201UEclipse Air LLC · Versailles, MON4211HRn Roofing LLC · Brandon, MSN4212HG And H Aviation · Louisville, KYN4218HGenna Aviation LLC · Newfield, NJN4220HHutchinson Keith M · Lancaster, TXN4222Barry Edwin R · Apple Valley, CAN4222HCre Aviation Holdings LLC · Ramona, CAN4227HMccharters LLC · Hobe Sound, FLN4232HHupp Garrett · Sunbury, PAN4234HKacprzak Dominik · Kingwood, TXN4235HJunker Gregory G · Cincinnati, OHN4239HGray Steven Don · Tualatin, ORN4244HLeung Henry C · Simsbury, CTN4247HRimensberger Boris D Trustee · Fullerton, CAN4248HGay Arnash · Harrison, OHN4256HJeffers Chadwick Ray · Glencoe, ALN4258HCeason Jeffrey M · Tucson, AZN4262HNorthern Iowa Anesthesia Services P L C · Ames, IAN4267HGmt Enterprises LLC · Stephenville, TXFirst renewal noticeN4269HSiniakin Michael K · East Brunswick, NJN4273HWooten William E Jr · Taft, TNN4289HGiguere Michael R · Danielson, CTN4293HHelleberg John R · Centreville, VAN4297HAirswiss Inc · Wilmington, DEN4305HTylski Aero Services LLC · Valley, NEN4322H4322h Rescue LLC · Oakland Park, FLN4323HRucker Edward A · Longview, TX
Back to Mooney M20J