Skip to content

Registered aircraft · 31

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 ('4470502')
  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 ('4470502')
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.

N115ACRuhlman Dan C · Youngsville, PABuilt 1968 · S/N 580367 N22730Reynolds Darryl G · Wills Point, TXBuilt 1969 · S/N 790436 N267RWKoelzer Galen G · Othello, WABuilt 1964 · S/N 0047 N3TFHelicopter Accessory Service East · Pensacola, FLS/N 34-0042 N451JRFathom Aviation LLC · Burley, WAS/N 65-0212 N525GHLauff Samuel Jr · Ocala, FLBuilt 1964 · S/N 87 N691RRAnderson Stuart R Jr · Sahuarita, AZS/N 124-0143 N911VCDetgen Ernest J · Carmen, OKBuilt 1965 · S/N 124-0144 N9323FCouch Bill A · Palestine, TXBuilt 1964 · S/N 24-0025 N9326FLelys · Orland, CABuilt 1964 · S/N 24-0031 N9333FFire Bird Aviation Inc · Vivian, LABuilt 1964 · S/N 34-0040 N9350FSale Reported · Perry, GASale reported, pending cancellationBuilt 1964 · S/N 0045 N9361FRmw Services LLC · Mckee, KYBuilt 1964 · S/N 54-0082 N9369FSauer David A · Palmetto Bay, FLBuilt 1964 · S/N 44-0070 N9374FPierson Robert N · Nora, MNBuilt 1964 · S/N 54-0086 N9385FReynolds Darryl G · Wills Point, TXBuilt 1964 · S/N 74-0112 N9390FPennington Mitchell T · Medley, WVS/N 74-0114 N9423FAvex Holdings Heli Inc · Lewes, DEBuilt 1965 · S/N 65-0207 N9428FBargo Aviation Services LLC · Crittenden, KYBuilt 1965 · S/N 0175 N9440FPatton Phillip F · Gold Hill, NCBuilt 1965 · S/N 55-0195 N9442FRhodes Terry G · Snohomish, WABuilt 1966 · S/N 115-0213 N9468FColeman Harold D · Pikeville, KYBuilt 1966 · S/N 106-0264 N9485FGonzales David M · Corvallis, ORBuilt 1966 · S/N 1260294 N9489FHensley Richard · Bertram, TXS/N 870325 N9504FRons Air Service Inc · Two Buttes, COBuilt 1968 · S/N 870334 N9516FKelly David · Issaquah, WABuilt 1967 · S/N 170311 N9517FS Martinez Livestock Inc · Moxee, WABuilt 1967 · S/N 170312 N9559FGeco Inc · Wilmington, DEBuilt 1969 · S/N 890443 N9561FBarrows Carl A · Lisle, NYBuilt 1970 · S/N 200450 N9563FClunie David A · Bangor, PABuilt 1971 · S/N 200447 N9569FClassic Helicopter Corp · Auburn, WABuilt 1971 · S/N 310461

Back to Hughes 269B