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.

N9253VChristopher Damien · Savannah, GAS/N 690056N92544Walther Newell A · Wasilla, AKBuilt 1946 · S/N 12-73N92545Grald Jonathan · New Hampton, NYBuilt 1946 · S/N 12-74N92547Haynes John · Gainesville, GABuilt 1946 · S/N 12-76N92548Pulliam Richard W · Henryetta, OKBuilt 1973 · S/N 17261584N92549Mackay Chadd P · Spokane Valley, WABuilt 1946 · S/N 12-78N9254CFlight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11183N9254EMoore Thomas R · North Bay, NYS/N 7147CN9254HShipley Donald E · Alpine, TXBuilt 1975 · S/N 17266049N9254KBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 28-7690237N9254LDeyager John E · Chapel Hill, TNBuilt 1971 · S/N AA1A-0154N9254MWhittaker Victor · Panama City Beach, FLBuilt 1966 · S/N 1201N9254PMeyer Aviation LLC · South St Paul, MNBuilt 1968 · S/N 24-4752N9254SHolmes Jeffrey T · Oxford, CTBuilt 1975 · S/N M-1751N9254VLeyden Jar LLC · Greeneville, TNS/N 690066N9254WVan Metre Steven · Bel Air, MDBuilt 1967 · S/N 28-10926N9254YFlorida Memorial University Inc · Miami Gardens, FLBuilt 2012 · S/N 172S11192N92556Bender Ronald J · Columbus, NMBuilt 1946 · S/N 12-85N9255AHotel Security Group LLC · Duluth, GABuilt 1998 · S/N 18280144N9255BAero Partners LLC · Sioux Falls, SDBuilt 1995 · S/N 4622197N9255CD&J Aviation LLC · Apopka, FLBuilt 1978 · S/N 28-7890393N9255DNorstrom Hans P · Wasilla, AKBuilt 1958 · S/N 18-6548N9255LBegley Edward R · Glasgow, KYBuilt 1971 · S/N AA1A-0155N92563Tri-County Sprayers Inc · Hamlin, TXBuilt 1946 · S/N 12-92N92569Bauer Dereck R · Springfield, ORBuilt 1946 · S/N 12-98N9256CBluegrass Aviation LLC · Clarksville, TNBuilt 1978 · S/N 28-7890394N9256DGonitzke Ross J · Detroit Lakes, MNBuilt 1995 · S/N 2890227N9256GGeib Gary D · Lake Tapawingo, MOS/N 476 DAF-2N9256MLone Star Magni Gyro Inc · Taylor, TXBuilt 1966 · S/N 3453N9256VDirschka Paul · Blandford, MABuilt 1969 · S/N 690067N9256XBird Acquisition LLC DBA · Phoenix, AZBuilt 1995 · S/N 4496002N92570Becker Steven H · Prescott, AZBuilt 1973 · S/N 17261586N92571Ag Air Squadron Three LLC · Saint Joseph, ILBuilt 1946 · S/N 12-101N92576Oman Ronald G · Chugiak, AKBuilt 1946 · S/N 12-106N9257CAcorn Aviation LLC · Saint Charles, ILBuilt 1978 · S/N 28-7890395N9257HTaf Aerial Services LLC · Beeville, TXBuilt 1981 · S/N 18267928N9257JWojtecki Chris R · Florissant, COBuilt 1966 · S/N 28-3333N9257MMouser Ryan D · Paragould, ARBuilt 1966 · S/N 3454N9257PBrooks Laura · Palmer, AKBuilt 1970 · S/N 18-8900N9257VKelley Gaylord L Jr · Murrells Inlet, SCBuilt 1969 · S/N 690057N92582Eichner Kenneth B · Ketchikan, AKBuilt 1946 · S/N 12-112N92583Church Bryce G · Lava Hot Springs, IDBuilt 1946 · S/N 12-113N92585Hines Thomas J · Anchorage, AKBuilt 1946 · S/N 12-115N92587Harper Thomas R · Lakeway, TXBuilt 1946 · S/N 12-122N92588Graham Aviation LLC · Baton Rouge, LABuilt 1946 · S/N 12-118N9258CBack Forty Flying Club Inc · Roanoke, INBuilt 1995 · S/N 2843002N9258DFlansburg Robert D · Middletown, DEBuilt 1995 · S/N 3246007N9258JHummingbird Avaition LLC · Columbus, INBuilt 1966 · S/N 28-3334N9258MJones Mavin D · Monroe, UTBuilt 1966 · S/N 1203N9258NKma Aircraft Dream LLC · Osteen, FLBuilt 1995 · S/N 28-43014
Back to AD 81-18-04 R2