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.

N91372Higgins Robert S · Granbury, TXBuilt 1981 · S/N 38-81A0169N9137EAltitude Holdings LLC · Springfield, MOBuilt 1988 · S/N 3213010N9137HPilots Flying School LLC · Englishtown, NJBuilt 1975 · S/N 17265966N9137JYuma Piper Fliers · Yuma, AZBuilt 1966 · S/N 28-3190N9137ZBreza Thomas S · Laud By Sea, FLBuilt 1988 · S/N 3206042N91383Rieder Josh · Boone, NCBuilt 1981 · S/N 38-82A0021N91386Shred Box LLC · Hayesville, NCBuilt 1981 · S/N 38-82A0022N9138HMojo Flight Group LLC · Gainesville, GABuilt 1975 · S/N 17265967N91396Willard Malcolm · Williston, VTBuilt 1995 · S/N 24-3355N9139CA F S Inc · Grants Pass, ORS/N R18200416N9139TBoss Peter J · Bruce, WIBuilt 1968 · S/N M-1155N9139WAmestoy Flyers LLC · Spokane, WABuilt 1966 · S/N 28-10759N9139ZTseline Aleksei · Cary, ILBuilt 1992 · S/N 24-3285N913APeckenpaugh Dawson S · Worden, MTBuilt 1951 · S/N 22-219N913BN913b LLC · Eau Claire, WIBuilt 1999 · S/N 25035CN913CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8333N913CSSeaman Bruce M · Mohave Valley, AZBuilt 2021 · S/N 71112N913CVMansfield Douglas M · East Gull Lake, MNBuilt 2002 · S/N CV-3N913FBrooks Benjamin · Little Rock, ARBuilt 1991 · S/N 1801N913GDAir Charter Inc DBA · Culebra, PRBuilt 1970 · S/N 198N913GSStull Gary L · Lutz, FLBuilt 2001 · S/N 317N913HCRosoff Neil M · Scotch Plains, NJBuilt 2019 · S/N 92081N913JKKing Michelle L · Atlanta, GABuilt 1974 · S/N 1018-74N913LKKeller Logan · Vale, ORBuilt 2021 · S/N 70MN913MSCukovic Naim · Portsmouth, NHBuilt 1976 · S/N 28-7715094N913PCRodgers Contract Cutting Inc · Eagle Point, ORS/N 67-16857N913TAChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 15285317N913TGThomas Home Center Inc · Sheridan, ORBuilt 1985 · S/N 28-8616011N913WCPotts Seth A · Mabank, TXBuilt 2009 · S/N 81042N913WGGan Thomas W · Doylestown, PABuilt 2013 · S/N 91887N914Daiber Marcus · Jefferson, GABuilt 1972 · S/N 388HN9140DLee Gerald R · Glennallen, AKBuilt 1958 · S/N 18-6529N9140ESale Reported · Stockholm, SDSale reportedS/N 7112CN9140JKeller Michael A · South Lake Tahoe, CABuilt 1966 · S/N 28-3194N9140LPretorius Ellen T · Smithville, OHBuilt 1971 · S/N 807-71N9140TKay Aviation LLC · Merritt Island, FLBuilt 1968 · S/N M-1156N9140VN914ov LLC · Greensboro, NCBuilt 1969 · S/N 690028N9140XScoffield Russell C · Hayden, IDBuilt 1991 · S/N 24-3245N91414Richardson James R · Brandon, MSBuilt 1981 · S/N 38-82A0027N9141JArvizu Alberto P · Lake Havasu, AZS/N 28-3195N9141LAmerican Airpower Heritage Flying Museum · Dallas, TXS/N 808-71N9141RInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N 1323N9141VFlitton Mark S · Enterprise, ALS/N 690010N9141WSlater Daniel R · Springfield, OHBuilt 1966 · S/N 28-10762N9142CIndiana Aviation Inc · Nicktown, PABuilt 1978 · S/N R18200417N9142JKormash John A · Edgewater, FLBuilt 1966 · S/N 28-3196N9142KSwales Michael K · Harrisville, MIBuilt 1976 · S/N 28-7615177N9142PErickson Ralph E · Foristell, MOBuilt 1966 · S/N 24-4623N9142WArtman Holdings LLC · Safford, AZBuilt 1966 · S/N 28-10763N9143DHellberg Farms LLC · Lowden, WAS/N 18-6533
Back to AD 81-18-04 R2