Skip to content

Registered aircraft · 47,138

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:2000-23-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21') 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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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:2000-23-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
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.

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 N2914TTp Aviation Inc · Augusta, KSBuilt 1966 · S/N 320 N2914YBol Aero LLC · Beverly Hills, CABuilt 2004 · S/N 0859 N29151Inland Aerial Surveys Inc · Riverside, CABuilt 1968 · S/N U206-1121 N2915BRobble Group LLC · Center Valley, PABuilt 1986 · S/N E-2314 N2915CField Jeff H · Simi Valley, CAFirst renewal noticeBuilt 1954 · S/N 30815 N2915FStoffregen Thomas S · Milton, WVBuilt 1966 · S/N 18257015 N2915TSierra Canyon Enterprises · Big Bear City, CABuilt 1979 · S/N 28-7921041 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 N2916TLewis Paul A · Spring, TXBuilt 1966 · S/N 322 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 N2918RTown Thomas L · Chino Valley, AZBuilt 1968 · S/N 310G0118 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 N2919TParsons William Tony Jr · Medina, TNBuilt 1966 · S/N 325 N291ABSerafini Louis · Ringwood, NJBuilt 1970 · S/N D-9119 N291BPJackson Jeffrey L · Manchester, TNBuilt 1966 · S/N TC-979 N291CMAutorific High Performance Carwash Inc · Roxboro, NCBuilt 2007 · S/N TH-2195 N291DCT G Dunn Plumbing Inc · Hulls Cove, MEBuilt 1953 · S/N 30110 N291RBAbbott Air Inc · Hydro, OKBuilt 1982 · S/N 414A0836 N291SPBarr Air Patrol LLC · Mesquite, TXBuilt 1986 · S/N 18268546 N291XMccown Bobby E · Soldotna, AKFirst renewal noticeBuilt 1975 · S/N 6117C N29204Jms Aviation LLC · Waynesville, OHS/N U206-1162 N29209Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 21059832 N2920GStevenson Taylor A · Dallas, TXBuilt 1980 · S/N 340A0115 N2920KBowen Kenneth W · Bainbridge Island, WABuilt 1979 · S/N 18053130 N2920RCarboneau Luke · Las Cruces, NMBuilt 1962 · S/N 310G0120 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 N2921BMurray Michael E · Fallbrook, CABuilt 1964 · S/N D-7372 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 N2922ULowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1979 · S/N 34-7970377 N2923AWicklander Richard O · Spanaway, WABuilt 1953 · S/N 30123

Back to AD 2000-23-21