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 ('4470402')
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 ('4470402')
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.
N8724FDel Rio Aviation Inc · Paso Robles, CAN8733FLay Jerry K · Minonk, ILN8743FPrice Keyth E · Ossian, INN8746FLarsen Jeffrey A · Casa Grande, AZN8749FTsr Sky Chicken LLC · Cleveland, TXN8751FLay Jerry K · Minonk, ILN87592Sorensen Eric N · Hilo, HIN8768FReynolds Darryl G · Wills Point, TXN8773FSera/Southeast Regional Aviation Inc · Bowdon, GAN8774FReynolds Darryl G · Wills Point, TXN8781FClements Kenneth B · Laguna Niguel, CAN8782FDinger Kevin L · Naples, FLN8786FPrice Keyth E · Ossian, INN8799FNew England Equip Corp · Auburn, MARevoked, canceledN8800FWaller County Aviation Museum · Waller, TXN8802FMc Lane Jonathan T · Morrisville, NCRevoked, canceledN8803FAg Helicopters Inc · Ft Collins, CORegistration revokedN8821FRuhlman Dan C · Youngsville, PAN8823FHudson Valley Helicopters Inc · Wilmington, DEFirst renewal noticeN8828FJohnson Martin L · Agua Dulce, CAN8835FUniversal Exports LLC · Schuylkill Haven, PAN8836FWooding William W · Anacortes, WAN8840FPinchorski Ronald G · Wiconisco, PAN8845FDowning Darrell W · Drakesville, IAN8856FRotorcraft Unlimited LLC · Brooksville, FLN8863FCain James W · Big Rapids, MIN8866FReynolds Darryl G · Wills Point, TXN8871FGarvey Michael · Leesville, SCN8872FCameron William Douglas Jr · Lexington, VAN8887FNiec Steven M · Clio, MIN8891FDetgen Jim · Traverse City, MIN8901FBrookside Aero LLC · Grants Pass, ORN8911FA And J Aviation Services LLC · Titusville, FLN8913FLay Jerry K · Minonk, ILN8925FAztec Aviation · Geneseo, ILN8928FDenver Aerospace Science Museum · Watkins, CON8SLLauff Samuel Jr · Ocala, FLN90270Dunn Larry W · Anderson, SCN90271Gartman Jerald B · Morehead City, NCN90586Lauff Samuel Jr · Ocala, FLN9061RCavender Matt · Howe, TXN9061SObrien Derrick P · Lehigh Acres, FLN9064SCain James W · Big Rapids, MIN911THDagnon Scott R · Driggs, IDN9333VFletcher Jeffrey A · Belle Chasse, LAN95583Reynolds Darryl G · Wills Point, TXN983TLElwell Andrew L · Yelm, WA
Back to Hughes 269A