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.

N2333YSkillman Flying Services LLC · Brookshire, TXS/N 17700133 N2334CTallahassee Flying Club Inc · Tallahassee, FLBuilt 1978 · S/N R18200153 N23353Weems Widener E · San Antonio, TXBuilt 1974 · S/N 17264085 N2335EMindy Limited LLC · Muscatine, IABuilt 1978 · S/N 17271240 N2339LVadnais Dennis J Sr · Fort Edward, NYBuilt 1979 · S/N 3879A0728 N2339YGross Barbara J · Timber Lake, SDS/N 17700139 N233DPProp 2 Fox LLC · Hudson, OHBuilt 2003 · S/N 931-2003 N233MGFly Safe LLC · Belle Isle, FLBuilt 1980 · S/N R18201541 N233SFSale Reported · Wakarusa, INSale reportedBuilt 1999 · S/N 402-99 N233SHSieger Aviation Services Inc · Bismarck, NDBuilt 1979 · S/N 15283714 N233TCInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 17257920 N2340CWilliam J Davis · Bismarck, NDS/N R18200155 N2340UTex-Pan Aviation Inc · Amarillo, TXBuilt 1982 · S/N 21064779 N2341PJohnson Freddie III · Stafford, VAS/N 38-79A0952 N2342EWolf John J · Mooresville, NCBuilt 1978 · S/N 17271245 N2345Riotte Frederick · Suffield, CTS/N 17266419 N2345YJackson Shaun K · Tyler, TXBuilt 1967 · S/N 17700145 N2345ZRegistered aircraftBuilt 1977 · S/N 17270190 N2346VGauvreau Paul J · Lafayette Hill, PABuilt 1981 · S/N 38-82A0058 N2347YProctor Keith E · Paint Lick, KYBuilt 1968 · S/N 17700147 N2348BHuff Michael W · Fair Grove, MOBuilt 1978 · S/N 38-79A0020 N2348FBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 38-79A0400 N2349LPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-79A0729 N234BAJohnson Alan Lee · Pikeville, KYBuilt 2000 · S/N 869-2000 N234BPYoung Tim M Trustee · Edmond, OKBuilt 1992 · S/N 24-3283 N234BWWaring Marvin Barton · Anacortes, WABuilt 1979 · S/N P21000290 N234GAAllen Dean C II · Green Sea, SCBuilt 1967 · S/N 680036 N234GMCunningham Hal A · Standard, CABuilt 1976 · S/N 17266438 N234HBLentini Christopher · Ardmore, OKBuilt 1992 · S/N 692-92 N234JGBartlett William F · Jackson, WYBuilt 1975 · S/N 17265225 N234MPBaugher Gregory V · Hannibal, MOBuilt 1968 · S/N 680183 N234PCCaldwell Larry R · Florence, KYBuilt 1985 · S/N 17276321 N234PEDunn Linwood B · Franklin, TNBuilt 1968 · S/N 17701078 N234RATom Eaton Consulting LLC · West Sacramento, CABuilt 2003 · S/N 13512003 N234RCRonnie G Crider Pa · Clearwater, FLBuilt 1985 · S/N R18202012 N234SBDaly Arthur P · El Paso, TXBuilt 1981 · S/N P21000673 N234SFDriscoll David A · Savannah, TNBuilt 1999 · S/N 1278-99 N234TSGolod David A · Ossining, NYBuilt 1977 · S/N 17268634 N234VRSnyder Jack W · Cheney, KSBuilt 1976 · S/N 17267422 N234WAWiseman Aviation Inc · Flagstaff, AZBuilt 1975 · S/N 17265581 N234ZGAtlas Aviation LLC · Buckhannon, WVBuilt 1978 · S/N 17270998 N2350EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271246 N2351AChapman Thomas N · Harvard, ILBuilt 1978 · S/N 38-78A0649 N2351TAc Holdings II Inc · Arlington, TXS/N 38-78A0778 N2351YToes In The Sand LLC · Bentonville, ARBuilt 1967 · S/N 17700151 N2352PFriedman Samuel · Tamuning, GUS/N 38-79A0957 N2354EGaruda Flight Training LLC · Miami, FLBuilt 1979 · S/N 172-72777 N2354PS M R Racing & Aviation Inc · Wilmington, DEBuilt 1979 · S/N 38-79A0960 N2355AScott Wilson A · Norman, OKFirst renewal noticeBuilt 1978 · S/N 38-78A0650 N2355EAce Of Spades Aviation LLC · Las Vegas, NVFirst renewal noticeBuilt 1978 · S/N 17271248

Back to AD 80-25-07 R1