Registered aircraft · 2,131

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:2009-13-06-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:2009-13-06-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:2009-13-06-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:2009-13-06-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:2009-13-06-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:2009-13-06-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.

N302TAMidwest Flying Service LLC · Wilmington, DEBuilt 1980 · S/N 31T-8020046 N3032PMenard Charles H · Grand Blanc, MIBuilt 1957 · S/N 23-943 N303TSCheyenne Air LLC · Ocean City, NJBuilt 1981 · S/N 31T-8166007 N3048PMeginnes Mark A · Tucson, AZBuilt 1957 · S/N 23-959 N3049PTaildragger Aero LLC · Saint John, WABuilt 1957 · S/N 23-961 N305YWRichard L Richards P A Trustee · Coral Gables, FLBuilt 1977 · S/N 31-7852016 N3063PWillis William P Trustee · New Palestine, INS/N 23-981 N3066PMatanane Rokie C · Barrigada, GUBuilt 1957 · S/N 23-984 N3070PParker Anthony C · New Ipswich, NHBuilt 1957 · S/N 23-988 N3073PPerry Edward Glen Trustee · Ozark, ARBuilt 1957 · S/N 23-991 N3081PVan Zant Robert E · Salem, WIS/N 23-999 N3086HGenesis Aviation Enterprises Inc · Fort Lauderdale, FLS/N 27-7754144 N30CPSkyveris LLC · Simi Valley, CABuilt 1973 · S/N 27-7305022 N30DRRuble Force One LLC · Wilkinson, INBuilt 1978 · S/N 31-7912006 N30DUHtf Aviation LLC · Kalispell, MTS/N 31T-7720054 N30SAMsm30sa LLC · Jericho, NYS/N 31-7952142 N30SCRegistration Pending · Wauchula, FLRegistration pendingBuilt 1981 · S/N 31-8152098 N30TPLe Ciel Bleu LLC · Hudson, WIBuilt 1981 · S/N 31-8152062 N3119PKovacs Thomas A · Nashua, NHBuilt 1957 · S/N 23-1041 N311BBCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1966 · S/N 27-3313 N311JEJps Aviation LLC · West Chicago, ILS/N 27-7754053 N3126PJmc Duryea Investments LLC · Ocala, FLBuilt 1957 · S/N 23-1049 N3127PThorn Blake A · Coupeville, WAS/N 23-1050 N3129PJudie Bear Air LLC · Bend, ORBuilt 1957 · S/N 23-1052 N312AKSafeco Leasing LLC · Port Alsworth, AKBuilt 1973 · S/N 31-7305015 N312CDMcwhorter Properties Graysville LLC · Anniston, ALBuilt 1980 · S/N 31-8052182 N3132PSarratt Curtis H · Annapolis, MDBuilt 1957 · S/N 23-1056 N3133PLumley John J · Delray Beach, FLBuilt 1957 · S/N 23-1057 N3134PSchmidt Casey D · Cedar Rapids, IAS/N 23-1059 N3144PEurohaus LLC · Phoenix, AZBuilt 1957 · S/N 23-1075 N314K314-K Associates LLC · Stratford, CTBuilt 1983 · S/N 31-8352025 N314KBMatthews Grover C · Hardinsburg, KYBuilt 1958 · S/N 23-1391 N315AKAlsworth Glen R Sr · Port Alsworth, AKBuilt 1978 · S/N 317852083 N315NYPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754031 N315WSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1984 · S/N 425501015 N3161PEga Aero Specialty Services LLC · Beaufort, SCBuilt 1957 · S/N 23-1093 N3165PNordstrand Steven D · Oak Harbor, WABuilt 1957 · S/N 23-1097 N316AKKuspuk School District · Aniak, AKS/N 318152118 N316HABidzy To Hot Aana Corp · Dillingham, AKS/N 31-7652133 N317AKSafeco Leasing LLC · Port Alsworth, AKS/N 31-7752145 N317HABauer Aviation LLC · Saint Germain, WIBuilt 1977 · S/N 31-7812043 N317PZFairmont State University · Fairmont, WVBuilt 1980 · S/N 27-8054047 N317SFLasher Patrick R · Magnolia, DES/N 31-7300912 N3187PAir Over Ground LLC · Helena, MTS/N 23-1124 N318RHN72jp Inc · Annandale, VABuilt 1976 · S/N 27-7654184 N31932Air Cargo Solutions Inc · Two Rivers, AKBuilt 1973 · S/N 31-7405144 N31CRStory Aranzazu · Draper, UTS/N 31-8152011 N31DEBarber Deans Elliott III · Selma, ALBuilt 1961 · S/N 27-504 N31FACarlisle Robert · Pensacola, FLBuilt 1960 · S/N 27-215 N31NWAlpha Whiskey 2 LLC · Brandon, MSBuilt 1981 · S/N 318152139

Back to AD 2009-13-06 R1