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.

N9548UCharlton Daniel B · Frederick, MDBuilt 1977 · S/N AA1C0044N9548WZh Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280512N9549FJogger Industries LLC · Sherwood, NDBuilt 1998 · S/N 17280514N9549HBenson Edward A · San Antonio, TXBuilt 1975 · S/N 17266221N9549LAmbrose Martin S · Springfield, MABuilt 1974 · S/N AA5-0549N9549TWilliams Dan John · Phoenix, AZBuilt 1978 · S/N 38-78A0129N954AReber Stephen D · Corrales, NMBuilt 1951 · S/N 22-266N954BCCarter Bradley S · Shawnee, KSBuilt 2022 · S/N 090N954FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13279N954GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881082N954JMccoy Heather S Trustee · Dayton, NVBuilt 1989 · S/N 2811031N954JHWings Over Texas LLC · Denton, TXBuilt 1975 · S/N 17266220N954KAirmart Aircraft Holdings Inc · Oak Ridge, NCBuilt 2000 · S/N 3246170N954LTWc Flight LLC · Higgins, TXBuilt 1993 · S/N 1252N954MMMagnuson Vernon S · Olathe, KSBuilt 2012 · S/N 73296N954MTMiddle Tennessee State University Aerospace · Murfreesboro, TNBuilt 2022 · S/N 40.1235N954NBreda John A · Needham, MABuilt 1968 · S/N 680131N954PCFinding Water LLC · Schwertner, TXS/N 18-3270N954RAAstillero Ricardo · Northfield, NJBuilt 1968 · S/N TD711N954RCKingsley Duke LLC · Franklin, NCBuilt 2011 · S/N 90821N954SASunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280626N954SCBair James R · Lucas, IABuilt 2021 · S/N JA1711116N954TGm Aviation LLC · Phillips, WIS/N 18-8649N954TCCohbro Aviation Inc · Bloomfield, CTBuilt 2003 · S/N 3232012N954TEBabin Michael K Jr · Cresson, TXBuilt 2004 · S/N 10233N954TPJabola Benjamin Andrew · Reston, VABuilt 1996 · S/N 94-0076N9550BMccall Freddie W · Brewton, ALBuilt 1981 · S/N 172RG0872N9550GCopper Skies Aviation LLC · Mesa, AZBuilt 1998 · S/N 17280516N9550JRodriguez Gerald · West Hempstead, NYBuilt 1966 · S/N 28-3680N9550LSale Reported · Colorado Springs, COSale reportedS/N AA5-0550N9550MAccess Chicago Inc · Orland Park, ILBuilt 1966 · S/N 670127N9550QDecatur Aero Club Inc · Decatur, ILBuilt 1998 · S/N 17280517N9550SBald Eagle Enterprises Inc · Nashville, TNBuilt 1999 · S/N 17280758N9550UAsplundh Eric P · Bryn Athyn, PABuilt 1977 · S/N AA1C0046N9551BLopes Gaston A · Dallas, TXS/N 172RG0873N9551DHhd Aviation LLC · Hamilton, OHS/N 22-6468N9551JKemp Richard · Manassas, VABuilt 1966 · S/N 28-3681N9551MLoafman Michael A · Bowling Green, KYBuilt 1966 · S/N 670128N9551WBcbc Aero Services LLC · Dover, DEBuilt 1998 · S/N 18280207N9552Runge Kerry A · Crystal Lake, ILBuilt 1978 · S/N 056N9552AAmeriflyers Of Texas Inc · Addison, TXBuilt 1998 · S/N 17280531N9552HZulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1975 · S/N 17266223N9552JStrong Dennis L · Minocqua, WIBuilt 1966 · S/N 28-3682N9552KWing Flying Club Inc · Lees Summit, MOBuilt 1976 · S/N 28-7690258N9552LHollin Myron · Guilford, INBuilt 1974 · S/N AA5-0674N9552RCauv LLC · Cincinnati, OHBuilt 1998 · S/N 18280167N9552SSmith Ranch Inc · Broadus, MTBuilt 1965 · S/N 42N9552UStrusa Steven J · Portsmouth, VABuilt 1977 · S/N AA1C0048N9552VRico Aviation Services Inc · Miami, FLBuilt 1974 · S/N 17264354N95537High Expectations LLC · Wilmington, DEBuilt 1984 · S/N 15285916
Back to AD 81-18-04 R2