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.

N9757JCarbiener Diane M · Kewanee, ILBuilt 1967 · S/N 28-3949N9757LGasper Joseph · New Port Richey, FLBuilt 1972 · S/N M-1378N9757TDevevo Warren C Sr · Sylvania, GABuilt 1978 · S/N 38-78A0189N9757UFairchild James C · Pinson, TNS/N AA5A-0157N9757WTld And Company LLC · Trenton, FLBuilt 1967 · S/N 28-23241N9758BSherwood Aviation LLC · Lewes, DES/N 172RG1015N9758DEvans Michael K · Nome, AKS/N 22-6672N9758JKiarsis Stephen G · West Wareham, MABuilt 1967 · S/N 28-3950N9759HHavelka Glen C · Boerne, TXBuilt 1981 · S/N 18268001N9759JLazy H LLC · Carleton, NEBuilt 1967 · S/N 28-3951N975AAEmez Holdings LLC · Boca Raton, FLBuilt 1974 · S/N 3175N975ACNaples Air Center Inc · Naples, FLBuilt 1978 · S/N 28-7916121N975BESaucerman & Company LLC · Hampstead, NCBuilt 1996 · S/N 3246040N975BMMeier Frank I Jr · Twin Lakes, WIS/N 70072N975BSSaurdiff Benjerman D · Two Rivers, AKBuilt 1979 · S/N 302-79N975BWWeidendorf Investments LLC · Hinckley, MNS/N 17270718N975CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281975N975DGPhillips Duke · Hyattville, WYBuilt 2000 · S/N 2112N975DSJpm Aviation LLC · Irvine, CABuilt 2009 · S/N 40.1065N975GPSalah Danny · Moraga, CABuilt 2017 · S/N 90975N975LEBlue Borracho LLC · Manitou Springs, COBuilt 1975 · S/N 28-7690001N975LLWoodhouse William H · Power, MTS/N 975N975PKMaisel Chad · Plano, TXBuilt 1971 · S/N 480N975RVArvai Joseph · Elkridge, MDS/N 40976N975SGage Christopher R · Truckee, CABuilt 1999 · S/N 1263-99N975TAMitchell David G · Cadiz, OHBuilt 2002 · S/N 172S9257N975THAnson Air LLC · Sugar Land, TXBuilt 2023 · S/N 172S12975N975VTDodd Park A · Richmond, VABuilt 2011 · S/N 40309N976Green Alexander · Germantown, TNBuilt 1985 · S/N 673N9760CStreet Steven J · Rochester, MIBuilt 1978 · S/N 28-7816526N9760DDavis Michael P · Midway, UTBuilt 1959 · S/N 22-6675N9760JHanks Cathy J · Danville, KYBuilt 1967 · S/N 28-3953N9760MNeal Alan B · Cherry Valley, CABuilt 1967 · S/N 670054N9760UFitzgerald John P · Pittsburgh, PABuilt 1976 · S/N AA5A-0160N9760WRegistered aircraftBuilt 1967 · S/N 28-23244N9761PBig Q Aviation Corporation · Helena, MTBuilt 1975 · S/N 18-7609025N9761WRivera-Osorio Karolina · Monroe, NYS/N 28-23245N9762DMarshall Marcus D · Georgetown, TXBuilt 1959 · S/N 22-6677N9762PKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1974 · S/N 25-7556072N97632Henderson James L · Jackson, MSBuilt 1969 · S/N 697632N9763HReed Grain & Bean Inc · Buhl, IDBuilt 1981 · S/N 18268004N9763JShaffer Timothy R · Marion, IABuilt 1967 · S/N 28-3958N9763MWaldren Paden · Garden Valley, CABuilt 1967 · S/N 670057N9763TBiotech Vending LLC · Escondido, CABuilt 1978 · S/N 38-78A0192N9764FFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1997 · S/N 17280042N9764KSchoff Wardell R · Hamilton, MOBuilt 1977 · S/N 28R-7837038N9764MSilcott Robert W III · Fairview, OKBuilt 1967 · S/N 670058N9764WMich John D · Fort Morgan, COBuilt 1967 · S/N 28-23250N97650Updraft LLC · Kissimmee, FLS/N 17276218N9765DPatey Daniel J · Lakewood, CABuilt 1959 · S/N 22-6680
Back to AD 81-18-04 R2