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.

N8888SStrizki Brian J · Flemington, NJBuilt 2002 · S/N 80624N8888WHoffman Jackie R · Friend, NEBuilt 1964 · S/N 28-10449N8888YPriebe Rodney M · Wasilla, AKBuilt 1973 · S/N 18-7409028N8889EWestern New York Flying Club Inc · Bowmansville, NYBuilt 1976 · S/N 28-7690214N8889VGarcia Hector A · Caguas, PRBuilt 1974 · S/N 17264247N8889WNedoba John · Stevensville, MIBuilt 1964 · S/N 28-10450N888ADAlirio Land Services · Miami Gardens, FLBuilt 1968 · S/N 28R-30913N888AGKlingensmith John R · Santa Maria, CABuilt 1998 · S/N 1042N888APAnderson Scott · Edgartown, MABuilt 1976 · S/N 28-7715105N888AWCag International Inc DBA · Longmont, COBuilt 1973 · S/N 28-7305386N888BMDeverapalli Vishnu Reddy · Duluth, GABuilt 1977 · S/N 28-7890282N888BWAero Elite Inc · Wilmington, DEBuilt 1970 · S/N 28-5856N888CBBenz James E · Pittsford, NYBuilt 1974 · S/N 17264417N888CCStevens Terry L · New Plymouth, OHBuilt 1979 · S/N 28-7916324N888CFJph Aviation LLC · Pittsburgh, PABuilt 1965 · S/N 457N888CKRadel James C · Sunbury, PABuilt 1989 · S/N 888PMN888CMKelley Aircraft LLC · Weyers Cave, VABuilt 1976 · S/N 17267424N888DEWeyls Daniel Christopher · Medina, OHBuilt 2010 · S/N 18282228N888DLCsc Enterprises Inc · Atlanta, GABuilt 1999 · S/N 2980N888EJInternational Air Services Inc Trustee · Carson City, NVS/N 2816082N888ERFrost Aviation Alliance LLC · Tampa, FLBuilt 1974 · S/N 28-7505087N888EXTuinstra Aaron C · Marinette, WIBuilt 2013 · S/N 83233N888EZRabideau Jacob N · Tehachapi, CABuilt 1983 · S/N 564N888FF2826 LLC · Inola, OKBuilt 2007 · S/N 40218N888GCBachmann Aviation LLC · Marshall, VABuilt 2005 · S/N 3857N888GHCardinal Gregory Joseph · Minneapolis, MNBuilt 1992 · S/N 52N888GMStevens Ryan · Presque Isle, MEBuilt 1977 · S/N 28-7716264N888GRGraves George L · Brownville, MEBuilt 1996 · S/N 3882N888HACm3 LLC · North Las Vegas, NVBuilt 2006 · S/N 11032N888HUPeoples Michael L Jr · Rockwall, TXBuilt 1998 · S/N 1397N888JDThille Nicholas M · San Luis Obispo, CABuilt 1968 · S/N TD-720N888KCGrimes Joshua R · Lock Haven, PABuilt 1978 · S/N 38-78A0115N888KHFranklin Vernon L · Aguila, AZBuilt 2005 · S/N 25478N888LAFrank John F · Baden, PABuilt 1987 · S/N 001N888LCDay Michael J · Fort Wayne, INBuilt 1964 · S/N 30-272N888LEStockton Raymond L · Pearl City, HIS/N 15279620N888LHReece Connor I · Green Cove Springs, FLBuilt 1997 · S/N 21045N888LUFourth Stoop Flyers LLC · Manakin Sabot, VABuilt 2012 · S/N 172S11206N888QCShipley Ryan Paul · Keller, TXBuilt 1977 · S/N 28-7716175N888SKKelly Erin C · Bend, ORBuilt 1978 · S/N 7-0407N888SNSkylands Air LLC · Port Orange, FLBuilt 2019 · S/N 30055N888TACurrier Winston F · Monroe, NHBuilt 1975 · S/N 17266196N888TBBlock Scott · Chandler, AZFirst renewal noticeBuilt 1969 · S/N 17257895N888TGSkylens LLC · Hammond, LABuilt 1976 · S/N 27-7654032N888TSSeher Jacob Scott · Reno, NVBuilt 2000 · S/N 80556N888UULake Ozark Helicopters Inc · Lake Ozark, MOS/N 10166N888VMDaniels Michael R · Mc Donald, PABuilt 1973 · S/N 17702021N888VPKokomo Aircraft Sales And Leasing LLC · Kokomo, INBuilt 1994 · S/N 3213073N888VRChambers Donald R II · Medford, ORBuilt 1999 · S/N 80356N888VTPam Aire LLC · Cedar Hill, TXBuilt 1968 · S/N 28R-30842
Back to AD 81-18-04 R2