OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,349

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
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-02-R2')
    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-02-R2')
  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.

N72WACrosby Seth J · Anchorage, AKS/N WA-72N7305LHill Stephen C · Fort Collins, COBuilt 1978 · S/N A1520780N730KFZero Kilo Foxtrot LLC · Grand Junction, COBuilt 2016 · S/N KA12037223N7315HGehrlein Rodney L · Waterford, PABuilt 1946 · S/N 20577N731JSNapier James C · San Diego, CABuilt 1984 · S/N 731N731TDJohnson Thomas R · Lancaster, OHBuilt 2014 · S/N 65-8634N7321BAdvanced Aviation School LLC · Venice, FLBuilt 1977 · S/N A1520743N7330BLogan Richard M · St Louis Park, MNBuilt 1977 · S/N A1520746N7336BWild Robert · Woodbury, NJBuilt 1977 · S/N A1520750N733MWWebb Matthew · Denton, TXBuilt 1967 · S/N 7GCBC-15N7340BThaut Lance A · Fullerton, CABuilt 1977 · S/N A1520752N7340LAzure 01 LLC · Canton, NYBuilt 1978 · S/N A1520792N7348BPatry Andrew · El Mirage, AZBuilt 1977 · S/N A1520753N7349BWilliams Kiplin S · Midland, NCBuilt 1977 · S/N A1520754N7356LCrosetto Pierre F · Downey, CABuilt 1972 · S/N AA1B-0056N7358LMariette Robert K · Happy Camp, CABuilt 1972 · S/N AA1B-0058N7380LAsiatico Ruperto M · Virginia Beach, VABuilt 1978 · S/N A1520799N738EMBaalman Roger H · Owasso, OKS/N 9293-788N7391LAbdulshafi Ahmed Jason · Oxnard, CABuilt 1978 · S/N A1520808N7392LKnowles Charles M Jr · Chapmanville, WVS/N A1520809N7395LCatherines Aviation Services LLC · Sewanee, TNBuilt 1978 · S/N A1520812N7397BAerolina Inc · Hendersonville, NCBuilt 1977 · S/N A1520766N7398LNelson Gregory J · Newcastle, CABuilt 1978 · S/N A1520815N73CVLiberatore A H Bud · Eagle Point, ORBuilt 1973 · S/N C1 5-6-30N73DCTwin Aviation LLC · Liberty Hill, TXS/N AA1A-0418N73VMSecurcloud LLC · Castleton, NYBuilt 1978 · S/N AA1C0128N7420KGonzales Kevin F · Alger, OHBuilt 1950 · S/N 20-330N744JAWiebe Albert · Seminole, TXBuilt 1968 · S/N 615N746ACCaldwell Robert I · Danville, KYBuilt 1946 · S/N 7AC 6008N7478BHenderson James L · Gordon, TXBuilt 1956 · S/N 7EC-536N747MSSabourin Michael L · Seattle, WABuilt 1995 · S/N 1374N747WTHovey Yvonne L · Attica, MIBuilt 1979 · S/N WA19N747ZPAuburn Valley LLC · Farmington, MNBuilt 1977 · S/N 15279476N748WHHuete Charles W · Carriere, MSBuilt 1969 · S/N AA1-0297N749REWheatley John P Jr · Thorp, WABuilt 2007 · S/N 0001N749TFNavmar Applied Sciences Corp · Ivyland, PABuilt 2024 · S/N TRC0004N74FCParry Mark W · Homestead, FLBuilt 2019 · S/N 7510495N7500HRobinson Eric C · Palmer, AKBuilt 1946 · S/N 12-361N7502FBarrie Lorna D · Tonawanda, NYBuilt 1969 · S/N 713N7502HCountry Air Service Inc · Hecla, SDS/N 12-363N7503FPatton David · Elmendorf, TXBuilt 1969 · S/N 714N7504FDerr Michael K · Maitland, MOBuilt 1969 · S/N 715N7504HSmokovitz Tyler · Fenton, MIBuilt 1946 · S/N 12-365N7505FIpme Management Corp · Jefferson, GABuilt 1969 · S/N 716N7506FOklahoma Airmen Flying Club Inc · Jenks, OKBuilt 1969 · S/N 717N7507FThomson Mary Ellen · East Berlin, PABuilt 1969 · S/N 718N7508KRegistered aircraftBuilt 1950 · S/N 18-221N750FYShuck Matthew M · Merrill, ORBuilt 2012 · S/N 75-8309N750XAMiller Peter D · Vernon, VTBuilt 2017 · S/N C75-10614N750XSSchmalzel Douglass A · Allenton, MIBuilt 2021 · S/N 75-8584
Back to AD 80-25-02 R2