Skip to content

Registered aircraft · 20,483

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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.

N29114Grey Goose LLC · Wasilla, AKBuilt 1968 · S/N U206-1084 N2911DPagano Ralph V · Cranbury, NJBuilt 1979 · S/N 18267459 N2911EAsphaltresource.Com LLC · Schwenksville, PABuilt 1982 · S/N 18268220 N2911FRegistration Pending · Fayetteville, ARRegistration pendingBuilt 1966 · S/N 18257011 N2911YBennett John M · Cameron, NCBuilt 1962 · S/N 18253911 N29127Shivers William L Jr · Friday Harbor, WABuilt 1968 · S/N U206-1097 N2912CMarshalee Arizona LLC · Tempe, AZBuilt 1954 · S/N 30812 N29130Ernst Gregory R · Eagle Creek, ORS/N U206-1100 N29138Allen Brent H · Mammoth Lakes, CABuilt 1973 · S/N 21059815 N2913CUnable Direct LLC · Kalispell, MTBuilt 1954 · S/N 30813 N29142Hall Darryl Wayne II · Wasilla, AKS/N U206-1112 N2914CSterkel Jared · Anchorage, AKBuilt 1954 · S/N 30814 N2914FHarris Zadok · Upland, CABuilt 1965 · S/N 18257014 N2914KWildness Aviation Limited · Morrison, COS/N 18053127 N29151Inland Aerial Surveys Inc · Riverside, CABuilt 1968 · S/N U206-1121 N2915CField Jeff H · Simi Valley, CAFirst renewal noticeBuilt 1954 · S/N 30815 N2915FStoffregen Thomas S · Milton, WVBuilt 1966 · S/N 18257015 N29164Iturriria John · Kuna, IDBuilt 1968 · S/N U206-1133 N2916AMetro Service Air Inc · Fairbanks, AKBuilt 1953 · S/N 30116 N2916FAndros Marketing LLC · Fort Lauderdale, FLBuilt 1966 · S/N 18257016 N29173Aerial Transport LLC · Wilmington, DEBuilt 1968 · S/N U206-1140 N29176Tgr Helicopters · Fresno, CABuilt 1973 · S/N 21059828 N2917CParks Joseph S · Wilmington, NCBuilt 1954 · S/N 30817 N2917FBennett David D · Clinton, WABuilt 1966 · S/N 18257017 N29181Wings Of Faith · Stevensville, MTBuilt 1968 · S/N U206-1147 N29186Thoroughbred LLC · Kalispell, MTBuilt 1968 · S/N U206-1151 N29188Rugger Investment Group LLC · Tustin, CABuilt 1968 · S/N U206-1153 N2918KHolmes Ronald W · Kent, ORS/N 18053128 N29190Mountain Helicopters LLC · Salt Lake City, UTBuilt 1973 · S/N 21059830 N2919CRudolph Darren M · Wasilla, AKBuilt 1954 · S/N 30819 N2919FPerez Adolfo · Conroe, TXBuilt 1966 · S/N 18257019 N2919KWoodaire Ltd · Coeur D Alene, IDBuilt 1979 · S/N 18053129 N291DCT G Dunn Plumbing Inc · Hulls Cove, MEBuilt 1953 · S/N 30110 N291JDDahapov LLC · Boca Raton, FLBuilt 2012 · S/N 18282322 N291SPBarr Air Patrol LLC · Mesquite, TXBuilt 1986 · S/N 18268546 N29204Jms Aviation LLC · Waynesville, OHS/N U206-1162 N29209Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 21059832 N2920KBowen Kenneth W · Bainbridge Island, WABuilt 1979 · S/N 18053130 N2920YApplegate Susan P · Decatur, TXBuilt 1962 · S/N 18253920 N29210Hawkes Brian R · Hamilton, MTBuilt 1968 · S/N U206-1165 N29217Dawson Adam J · Eveleth, MNBuilt 1968 · S/N U206-1171 N2921AStanford Jeffrey S · Anchorage, AKBuilt 1953 · S/N 30121 N2921CMensink David L · Preston, MNS/N 30821 N29224Phelan Ricky Ray · Jefferson, ORBuilt 1968 · S/N U206-1176 N2922AFowler Kenneth Russell · Locust Fork, ALS/N 30122 N2922FKalil Joseph J Jr · Morgan, UTBuilt 1966 · S/N 18257022 N2923AWicklander Richard O · Spanaway, WABuilt 1953 · S/N 30123 N2923KSallee Daniel C · Port Angeles, WABuilt 1979 · S/N 18053131 N2923YS & R Aviation Inc · Boise, IDBuilt 1962 · S/N 18253923 N2924ABennett Ross D · Anchorage, AKBuilt 1953 · S/N 30124

Back to AD 84-10-01 R1