AD 81-18-04 R2

Registered aircraft · 81,733

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:81-18-04-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:81-18-04-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.

N9467CDominy Alan L · The Woodlands, TXBuilt 1978 · S/N 28-7890413N9467DHahn Randal N · Wasilla, AKBuilt 1951 · S/N 18-863 MCN9467LFanego David · Cape Coral, FLBuilt 1971 · S/N AA1A-0267N9467WHartshorn Brian · Waynesville, OHBuilt 1968 · S/N 28-11192N94682Flight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11234N94684Delta State University · Cleveland, MSBuilt 1983 · S/N 15285763N94688Lyon Aviation Inc · Pittsfield, MABuilt 1983 · S/N 15285765N9468DKelly Henry Searles · Ossining, NYBuilt 1984 · S/N 172RG1177N9468FColeman Harold D · Pikeville, KYBuilt 1966 · S/N 106-0264N9468HShouse Andrew · Flagstaff, AZBuilt 1975 · S/N 17266169N9468JSheffield Glenn A · Houston, TXBuilt 1966 · S/N 28-3582N9468LGa N9468l LLC · Atlanta, GAS/N AA1A-0268N9468PSmall Alan J · Bristol, RIBuilt 1971 · S/N 24-4978N9469DRanney Gayle · Cordova, AKBuilt 1959 · S/N 18-6815N9469EParker Duane E · Louisville, KYBuilt 1979 · S/N 17272273N9469HAirplanes And Attitude LLC · Mckinney, TXBuilt 1975 · S/N 17266170N9469JNelson Stephen A · Milaca, MNBuilt 1966 · S/N 28-3584N9469LButler Mark E · Texarkana, TXBuilt 1971 · S/N AA1A-0269N9469VNorton Curtis S Jr · Beaver Falls, PAS/N 700038N946AKotranza Robert R · Houghton Lake, MIBuilt 1951 · S/N 22-252N946ACNaples Air Center Inc · Naples, FLBuilt 1985 · S/N 15286018N946AFDuke Kay L · Darrouzett, TXBuilt 1953 · S/N 18-2494N946BWhiteside William E · Talmage, CABuilt 1961 · S/N TD-478N946BDBeede Curtis M Trustee · Maineville, OHBuilt 2019 · S/N 1589N946BVAnton Bill · Satanta, KSBuilt 2022 · S/N 3735N946CCBrown C C · Laramie, WYS/N RV6A22289N946CHCritchfield Flying Service LLC · Rupert, IDBuilt 1977 · S/N 17269021N946CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282408N946CVLightcap Michael Wayne · Mc Alpin, FLBuilt 2000 · S/N 22004N946GSStage George A · Kirtland, OHBuilt 2010 · S/N 2070-LN946MSMt San Antonio College · Walnut, CABuilt 2015 · S/N 1411-2015N946PMMorgensen John D · Prescott Valley, AZBuilt 2013 · S/N 91269N946PTBrillo Benjamin G · Union City, CABuilt 2002 · S/N 5739N946RHMorcom Aviation Services Inc DBA · Everett, WABuilt 1977 · S/N 14223N946SFSnohomish Flying Service Inc · Snohomish, WABuilt 1978 · S/N 15282353N946SMEntrekin David C · Ridgeland, MSBuilt 1982 · S/N 17275870N946TEStrange Bird LLC · Hackensack, NJBuilt 2003 · S/N 10225N946THWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 172S13146N9470DJacko Josh E · Anchorage, AKBuilt 1959 · S/N 18-7016N9470WRegistration Pending · Cortez, CORegistration pendingBuilt 1968 · S/N 28-11196N94714Wright Aero Inc · Saint Cloud, MNBuilt 1983 · S/N 15285771N9471CHitpas Henry R II · Beaufort, SCBuilt 1978 · S/N 28R-7837200N9471DRasmuson Travis R · Helena, MTBuilt 1959 · S/N 18-7018N9471VJ S Alguire Consulting Forestry Services Inc · Dover, DEBuilt 1970 · S/N 700060N9471WMidway Enterprises Inc · Wilmington, DES/N 28-11198N9472FJunell Sonny Brian · Midlothian, TXBuilt 1988 · S/N 18280201N9472HMulder Terry A · Appleton, WIBuilt 1976 · S/N 17266171N9472JMarquette County Flying Club · Marquette, MIBuilt 1966 · S/N 28-3587N9472LBradt Jeffrey A · Charlton, NYBuilt 1971 · S/N AA1A-0272N9472WSelvaraj Mylappan · Butler, PABuilt 1968 · S/N 28-11199
Back to AD 81-18-04 R2