Registered aircraft · 25,370

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N169AJNolan Davis Dds LLC · Juneau, AKBuilt 1969 · S/N 17257981 N169DDFlughafen Skyport Ltd · Wilmington, DEBuilt 2001 · S/N 455-2001 N169ECFirst Eclipse Limited · Richmond, VABuilt 1980 · S/N 172RG0515 N169EZMallory Jessica Lynn · Anchorage, AKBuilt 1976 · S/N 927-76 N169FLBlue Moon Holding Co LLC · Boca Raton, FLS/N 17700047 N169HCButterfly Wings Of Miami LLC · Miramar, FLBuilt 1973 · S/N 17262693 N169JMBravo Alpha LLC · Driggs, IDBuilt 1978 · S/N P21000169 N169JWPatterson Matthew D · Knoxville, TNBuilt 1968 · S/N 17700360 N169NESouth Coast Aviation Inc · North Bend, ORS/N 17275794 N169PCSachau Glen R · Spearfish, SDBuilt 2004 · S/N 1359-2004 N16AHendrix Aviation LLC · Benton, ARBuilt 1978 · S/N R18200405 N16AXKing Austin · Abilene, TXBuilt 1980 · S/N 21064101 N16DBDivan Richard W · Wautoma, WIBuilt 1969 · S/N 17258618 N16DRHibner Christopher J · Canton, MIBuilt 1964 · S/N 416 N16DVDecathlon LLC · Herndon, VABuilt 2021 · S/N 1193-2021 N16EDSimply Living LLC · Fort Myers, FLBuilt 1985 · S/N 172RG1189 N16EFAnything Aviation LLC · Fort Lauderdale, FLBuilt 1977 · S/N 15280441 N16EKCenterline Holdings LLC · Belgrade, MTBuilt 1975 · S/N 17265927 N16GLDuncan David · Colorado Springs, COS/N 0772 N16MMGoff Bruce J · Williamstown, MABuilt 1981 · S/N 18268045 N16RGHomer Ace Inc DBA · Tulsa, OKBuilt 1969 · S/N 205 N16RRAustin Donald E · Ripley, MSBuilt 1979 · S/N 15283120 N16TPWorsham Farms Flying Service Inc · Camilla, GABuilt 1972 · S/N 302-72 N16VCStallion Leasing LLC · Louisville, KYBuilt 1976 · S/N 17267939 N16VUVipers United LLC · Stoughton, WIBuilt 1974 · S/N 438-74 N16WLLivingston Patricia R · Wasilla, AKS/N 17256545 N16ZAVisser Johannes Christoffel · Reno, NVBuilt 1980 · S/N 21063807 N17019Reed James W · Boulder City, NVBuilt 1976 · S/N 17702496 N1701DBlue Skies Aero LLC · Clovis, CABuilt 1981 · S/N 24-1156 N1701HAmelia Reid Aviation LLC · San Jose, CABuilt 1974 · S/N 454-74 N1701VBeach Chad T · Kilgore, TXBuilt 1974 · S/N 17262851 N1702EExecutive Flight Institute LLC · Murrieta, CABuilt 1978 · S/N 17271101 N1702RDaniel Boone Flying Club Inc · Booneville, MOBuilt 1978 · S/N R18200523 N1702VClassic Rotors Museum · Ramona, CABuilt 1974 · S/N 17263717 N17049101 Inc · Bejou, MNBuilt 1976 · S/N 17702497 N17050Findlow Jerry E · Glasser, NJBuilt 1976 · S/N 17702498 N17052Skypilot LLC DBA · Benbrook, TXBuilt 1976 · S/N 17702499 N17059N79107 LLC · Orrville, OHBuilt 1982 · S/N R18201915 N1705RCox Brian Allen · Pasadena, CABuilt 1978 · S/N R18200525 N1705VNiles Air LLC · Concord, NCBuilt 1974 · S/N 17263718 N1705ZJohnston Daryl T · Euless, TXBuilt 1973 · S/N 474-73 N17068Adamski Thomas R · Grantham, NHBuilt 1976 · S/N 17702501 N1707Qualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 24-0263 N17091Martin Stanley B · Lockhart, TXBuilt 1976 · S/N 17702502 N170MLLacey David G · Locust Grove, GABuilt 1974 · S/N 1074-75 N170SKNottingham John F · Covington, LABuilt 1979 · S/N 17273173 N170SPSweatt Jeffrey · West Terre Haute, INBuilt 1981 · S/N 17275097 N170SUTop Flight Consulting LLC · Fort Myers, FLBuilt 1979 · S/N 152-83248 N17102North Timothy · Milton, WVBuilt 1976 · S/N 17702503 N17132Harvey Laurence C · Lincoln, NEBuilt 1982 · S/N R18201921

Back to AD 80-25-07 R1