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.

N14281Technical Education Services Inc T/A · Virginia Beach, VABuilt 1972 · S/N 27-4843 N142VPMortland Thomas F · Duxbury, MABuilt 1959 · S/N 23-1593 N1432MLarson Sean P · Fairbanks, AKS/N 23-432 N14350Pema Aviation LLC · Tavernier, FLBuilt 1972 · S/N 27-7304933 N14368Semeniuk Steven T · Houston, TXBuilt 1972 · S/N 27-7304956 N14379Bas Part Sales LLC · Greeley, COS/N 27-7304970 N14386Blue Star Aviation Services LLC · Shippensburg, PABuilt 1972 · S/N 27-7304980 N1438PTri Rotor Spray & Chemical · Ulysses, KSS/N 23-496 N14394Pavco Inc · Gig Harbor, WABuilt 1972 · S/N 27-7304991 N143ACPotcake Aviation LLC · Missoula, MTBuilt 1972 · S/N 27-7304989 N14401Berggren Ryan · Newton, NJBuilt 1967 · S/N 27-3722 N144ASValiair Lc Trustee · Casper, WYBuilt 1973 · S/N 31-7300903 N144CNGalliot Bond LLC · Atlanta, GAS/N 27-8054036 N144PLCatskill Transportation LLC · Kingston, NYBuilt 1984 · S/N 42-5527014 N1452PSorenson Mark A · Senoia, GABuilt 1956 · S/N 23-515 N1454PLansing Community College · Mason, MIBuilt 1956 · S/N 23-517 N1455PMohamed Eman Z · Lubbock, TXBuilt 1956 · S/N 23-518 N1460PBas Part Sales LLC · Greeley, COS/N 23-523 N146DCAztec Worldwide Airlines Inc · Wilmington, DES/N 31-7305109 N146JMarc Inc · Bolton, MSBuilt 1977 · S/N 31-7852005 N1470BBerger Leo · Nampa, IDS/N 31-7512061 N1474PMccormick Robert E · Selah, WAS/N 23-541 N147ECAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1963 · S/N 27-2399 N14886Fat Aire Inc · Wilmington, DES/N 31T-7904036 N14934Csc Delaware Trust Co Owner Trustee · Wilmington, DEBuilt 1966 · S/N 27-3178 N149PCSubick Leonard · Spring City, PABuilt 1966 · S/N 27-3534 N14APGlobal Air Concepts LLC · Anchorage, AKBuilt 1977 · S/N 31-7752060 N14GSKerner Robert · La Vergne, TNBuilt 1971 · S/N 27-4637 N14NESchroeder David C · Norfolk, NEBuilt 1984 · S/N 31T-1104012 N14TNGonzalez-Ruiz Antonio R · Mountain Brk, ALBuilt 1981 · S/N 31T-8120060 N151STWildman Lake Lodge Inc · Anchorage, AKBuilt 1979 · S/N 31-8052036 N153EJQualitair LLC Trustee · MichelstadtBuilt 1983 · S/N 31P-8414011 N153LMSkylens LLC · Hammond, LABuilt 1976 · S/N 27-7754019 N153WBOster Dale E · Trego, MTBuilt 1966 · S/N 27-3329 N154CAFedair Inc · Indianapolis, INBuilt 1980 · S/N 31T-8020085 N154WWAlpha Whiskey 1 LLC · Brandon, MSS/N 31-7952230 N155EPGogoplex LLC · Wilmington, DEBuilt 1969 · S/N 27-4430 N155MCWhite Bay Aviation LLC · Corpus Christi, TXBuilt 1978 · S/N 31T-7820069 N1577RGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1981 · S/N 278154026 N158GEarle Norman R · Fairview, NCS/N 23-1521 N158JDNavajo N158jd LLC · Wilmington, DEBuilt 1981 · S/N 318152104 N158MHMansfield Heliflight Inc · Milton, VTS/N 42-5527006 N159BOppold Robert S · Overland Park, KSBuilt 1977 · S/N 27-7754047 N159DSynapse USA LLC · Mesa, AZBuilt 1974 · S/N 31P7530012 N159RSTechnical Education Services Inc · Virginia Beach, VAS/N 27-2817 N15FGShannon Jesse Lee · Boise City, OKBuilt 1975 · S/N 27-7554112 N15JEPremier Flight Center LLC · Hartford, CTBuilt 1964 · S/N 27-2494 N15KWRibitsch Robert L · Redondo Beach, CABuilt 1981 · S/N 31T-8166014 N15KYMcdougle Sean · Oklahoma City, OKBuilt 1965 · S/N 27-2780 N15REGreat Alaskan Flooring Inc · Kodiak, AKBuilt 1968 · S/N 27-4068

Back to AD 2009-13-06 R1