Skip to content

Registered aircraft · 97

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 ('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_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.

N1020QMike Rinker Aircraft LLC · Union City, TNS/N 115-0426 N1020STactical Turtle LLC · Sheridan, WYBuilt 1966 · S/N 26-0467 N1020TSchroth Charles D · Gustavus, AKBuilt 1966 · S/N 56-0554 N1020ZBowar Gary R · Miranda, SDBuilt 1966 · S/N 66-0601 N10375Tactical Turtle LLC · Ortanna, PAS/N 67-18376 N1038NSome Beech LLC · Bolivar, MOS/N 85-0360 N105CMLewis Donn C · Millington, MIBuilt 1966 · S/N 66-0587 N106KTDetgen Ernest J · Carmen, OKBuilt 1966 · S/N 46-0516 N110ESAirdale Helicopters LLC · Shawnee, OKS/N 58-0860 N153GHHealey David A · Hammondsport, NYBuilt 1966 · S/N 660602 N202SLConstantine Frank L · Flemington, NJBuilt 1969 · S/N 67-16975 N2196SHernandez Christopher A · Phoenix, AZBuilt 1968 · S/N 180753 N269AReynolds Darryl G · Wills Point, TXBuilt 1965 · S/N 1050403 N269HHCaprock Technical Services Inc · Kempner, TXS/N 12-0041 N269MDCactus Air Force LLC · Carson City, NVBuilt 1963 · S/N 33-0175 N269SRRaper David A · Mesa, AZS/N 16-0445 N269STSalina Tree Inc · Salina, KSBuilt 1965 · S/N 85-0363 N37750Bacon Gregory · Prairie Home, MOBuilt 1968 · S/N 680883(6716776)N380MCVeturis David L · Lake Forest, CAS/N 128-1054 N38ABJerry Lay Aviation LLC · Minonk, ILS/N 46-0503 N4276REchols Mark R · Diana, TXBuilt 1967 · S/N 1181032 N444EDunker Quinn E · Morse Bluff, NEBuilt 1963 · S/N 0217 N47SDWampler William C · Canton, TXS/N 108-0989 N48155Classic Rotors Museum · Ramona, CABuilt 1964 · S/N 160433 N49WGGarlock Walter G · Oconomowoc, WIS/N 760616 N5001FReynolds Darryl G · Wills Point, TXBuilt 1965 · S/N 95-0385 N50045Drive A Tank Inc · Kasota, MNBuilt 1966 · S/N 76-0610 N5594YWdw Aviation Leasing Inc · Knoxville, TNBuilt 1964 · S/N 1140329 N62269Ashcraft Matthew · Abbott, TXS/N 160449 N62273Mundell Terry Trustee · Rosston, OKBuilt 1969 · S/N 291096 N62293Bilsky William E · Titusville, FLS/N 88-0939 N6258BA&A Conveyor And Equipement Inc · Pennington Gap, VAS/N 67-16812 N653CHKelley Aviation Consultants LLC · S Williamsport, PABuilt 1965 · S/N 96-0653 N7032ZJones James William III · Lebanon, VAS/N 1040325 N7050DFoster David S · Justin, TXS/N 56-0551 N7057LTri County Rentals And Sales Inc · Chiefland, FLBuilt 1967 · S/N 1281052 N711CHYoung Vernon P · Metter, GAS/N 560531 N7233USuttle Joseph S · Moody, ALBuilt 1964 · S/N 16-0447 N72LTReynolds Cindy L · Wills Point, TXBuilt 1968 · S/N 580863 N74LTDevor Aviation Support Services LLC · Chambersburg, PABuilt 1968 · S/N 1270740 N801CPMoore Bradley J · Logsden, ORBuilt 1968 · S/N 980965 N801SLZadow Ryszard Jerzy · Waller, TXBuilt 1968 · S/N 880954 N8045SHenry Mark A · Dickinson, TXBuilt 1964 · S/N 85-0365 N8047LHolmes Frank L · Enterprise, ALBuilt 1967 · S/N 47-0699 N8049PFranklin Ricky L · Glade Hill, VAS/N 56-0535 N8049WTennis Gayland L · Bath, MIBuilt 1965 · S/N 75-0349 N8135LTri County Rentals And Sales Inc · Bell, FLS/N 580847 N8708FCruiser LLC · Munger, MIBuilt 1961 · S/N 111-0020 N8714FDown East Emergency Medicine Institute · Orono, MES/N 111-0027 N8719FKinzie Wayne · Alva, OKBuilt 1961 · S/N 121-0032

Back to Hughes 269A