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.

N93CFSink Abram T · Hillsboro, OHBuilt 1998 · S/N MK0052N93CSAngel Kyler A · Plains, KSBuilt 1993 · S/N 1N93DASeptember Bravo Enterprises LLC · West Olive, MIBuilt 2004 · S/N 2102N93DECore Peak Consulting LLC · Moorcroft, WYBuilt 1994 · S/N SUT604N93DJMacnicol Robert D · Bartow, FLS/N 1058N93DNRiseaero LLC · Florence, SCBuilt 1993 · S/N 712-93N93DSSrofe Danny D Jr · West Portsmouth, OHS/N 267 42 0708N93DTTolkach Dennis · Dunlevy, PABuilt 1993 · S/N 366-93N93EREdal Inc · Plantation, FLBuilt 1992 · S/N 10106N93ESTudor Daniel · Harlowton, MTS/N V94070012N93FFPeauy Mike J · Chico, CABuilt 1996 · S/N 13N93GFRanieri Realdo · Mesa, AZBuilt 1993 · S/N 367-93N93GGGosser Chad K · Russell Springs, KYBuilt 1964 · S/N 385N93GMPrice Justin E · Charlotte, NCBuilt 1992 · S/N 2240N93GPHorizon Helicopters Inc · Newark, DEBuilt 2005 · S/N 2117N93GWRegistration Pending · Glenn, CARegistration pendingBuilt 2001 · S/N 1N93HBVranes Michael · Zephyr Cove, NVBuilt 1981 · S/N 18267768N93HUFugleberg Lance R · Portland, NDBuilt 1993 · S/N 1249N93HYBorrego Farms Inc · Valley Center, CABuilt 2004 · S/N 2281N93JSNeptune Aviation Services Inc DBA · Missoula, MTBuilt 1972 · S/N 17260936N93KOdonnell Daniel V · Dover, DEBuilt 1973 · S/N 721LN93KCT I M E Flight Inc · Heber Springs, ARBuilt 1992 · S/N 3213041N93KKMonmouth Area Flying Club · Lakewood, NJBuilt 1975 · S/N 17266160N93KNPataky Gabriel J · Sarasota, FLBuilt 1993 · S/N 2890174N93LDMcnabb Ernest Mark · Somerville, TNBuilt 1995 · S/N D0001N93LRSuchomel Charles F · New Carlisle, OHBuilt 1975 · S/N RN2851N93MCGabel Allan · Oxnard, CABuilt 2013 · S/N 71004N93MGCastle Aviation Inc · North Canton, OHBuilt 1979 · S/N 6006707961211N93MLAsher Kevin C · Wasilla, AKBuilt 1993 · S/N 4114-CN93MVWell Bilt Industries USA LLC · Ocala, FLBuilt 1979 · S/N 27-8054029N93MYReuterskiold Jerold L · Friendship, WIBuilt 1994 · S/N 21001N93RFRegistered aircraftS/N 1787-LN93RPShafer Andrew · Phoenix, AZBuilt 1993 · S/N 21219N93RRReid Ronald T · Oxnard, CABuilt 2018 · S/N 91757N93RSJones Warwick L · Torrance, CAS/N 978N93RVMouliere Billy D · New Waverly, TXBuilt 1993 · S/N 20496N93SAOverbey Shane · Detroit, MIBuilt 1992 · S/N 1064N93SDRealtyaviation LLC · Key Largo, FLBuilt 2018 · S/N 18283036N93SKHall William N Jr · Cocoa Beach, FLBuilt 2012 · S/N 71806N93SMVilla Aviation LLC · Alpharetta, GABuilt 2000 · S/N 1290-2000N93TBWarmkessel James R · Felton, CAS/N 541N93TCPj Aviation Holding LLC Trustee · Eden Prairie, MNBuilt 2018 · S/N 3296N93TEOlwell Cheryl · Bulverde, TXBuilt 1977 · S/N AA5B0475N93TJSale Reported · Crystal, MNSale reportedBuilt 1969 · S/N 28R-35026N93UGBellas Business LLC · Kalispell, MTS/N 23-350N93VSLmh Industries Inc · Long Beach, CAS/N 126N93WEBoeing Employees Flying Assoc · Renton, WABuilt 1992 · S/N 659-92N93WKPiercy Ronald S · Moses Lake, WABuilt 1973 · S/N 643-74N93WPHbfc Inc · Tehachapi, CABuilt 1964 · S/N 28-20460N93WRDukic Slobodan · Jacksonville, FLBuilt 1977 · S/N 28-7890106
Back to AD 81-18-04 R2