Skip to content

Registered aircraft · 32

Aircraft of this model in the FAA registry, by N-number.

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 ('4470503')
  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 ('4470503')
ORDER BY n_number

Run 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.

N107BNBig Boy Toys LLC · Mars, PAS/N 701438 N126SRDown East Emergency Medicine Institute · Orono, MES/N 1091299 N13SDSnohomish County Sheriffs Office · Snohomish, WAS/N 380376 N142SCSpartanburg County Sheriffs Office · Spartanburg, SCS/N 1180910 N160DAWehring Justin DBA · Clute, TXBuilt 1969 · S/N 391115 N17167Slade Aviation LLC · Carlsbad, NMBuilt 1969 · S/N 491127 N17801Mckee John R · Central Point, ORBuilt 1968 · S/N 380352 N187YMBrown Byron Tim · Hermiston, ORS/N 691183 N2091RCity Of El Paso Police Department · El Paso, TXS/N 380381 N21772N21772 LLC · Wellington, FLBuilt 1967 · S/N 970134 N259BKCavanaugh Collections Inc · Addison, TXBuilt 1970 · S/N 301376 N262SDCullman Police Department · Cullman, ALS/N 691218 N278KCCullman Police Dept · Cullman, ALS/N 201371 N298SDCsw LLC · Anacoco, LABuilt 1968 · S/N 280332 N301SDHarrison County Sheriffs Department · Gulfport, MSBuilt 1967 · S/N 1070131 N305AZJta Express Inc · Wilmington, DEBuilt 1968 · S/N 480446 N330CMDewind Helicopter Services LLC · Zeeland, MIS/N 291060 N332ABUsda Aphis Ws Atoc · Cedar City, UTS/N 791231 N369KECbft LLC · Mobile, ALBuilt 1969 · S/N 991271 N387RFMid America Flight Museum · Mount Pleasant, TXBuilt 1969 · S/N 301381 N47267Mckee John R · Central Point, ORBuilt 1969 · S/N 68-17267 N535XOxford Police Department · Oxford, ALS/N 101356 N53HCDrive A Tank Inc · Kasota, MNS/N 301384 N56TWMckee John · Central Point, ORBuilt 1968 · S/N 1180880 N6246WStarfire Aviation LLC · Renton, WABuilt 1968 · S/N 880712 N658JLLauderdale Aeronautics LLC · Davie, FLBuilt 1969 · S/N 691194 N818SCHartland Helicopters LLC · Edinburg, TXBuilt 1967 · S/N 770093 N888DXAlexander Mary · Grants Pass, ORBuilt 1968 · S/N 380362 N888USAm Air Service LLC · Green Oaks, ILBuilt 1968 · S/N 180282 N911JXSt Louis County Police · Chesterfield, MOS/N 601424 N9792SGrand Haven Aviation Services · Spring Lake, MIBuilt 1966 · S/N 1060007 N99888Combat Rotors LLC · Eugene, ORBuilt 1969 · S/N 391105

Back to Hughes 369A