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.

N60FDBarnstorm Aero Inc · Sacramento, CABuilt 1983 · S/N 718N60GAGlidewell Aviation Inc · Parkland, FLBuilt 1978 · S/N 17271354N60GLMiko Pawel Marcin · Santee, CABuilt 1978 · S/N 0806N60GZAbl Aviation Inc Trustee · Wilmington, DEBuilt 1987 · S/N 24-3035N60HEagle Flight Squadron Inc · East Orange, NJBuilt 1973 · S/N 17261653N60HASteeneck Robert T · Washougal, WABuilt 1989 · S/N 219N60HCKing Winn K · Gladewater, TXBuilt 1996 · S/N 0287N60HFTexas Flying Club Inc · Bryan, TXBuilt 1977 · S/N 17270210N60HUOne Pft LLC · Denton, MTBuilt 1996 · S/N 1321N60HYAnderson James D · Russell, KSBuilt 2002 · S/N 2186N60JBHarmon Eagle LLC · Albuquerque, NMBuilt 1979 · S/N 483-79N60JKHiner Kirk J · Kenyon, MNBuilt 2004 · S/N 142N60KDBegeman Daniel L · Littleton, COBuilt 2007 · S/N 25620N60KRRhea Keith H · Peck, KSBuilt 2014 · S/N 74099N60LFNorthwoods Air LLC · Orono, MEBuilt 1978 · S/N 27-7854111N60LGEgmond Aircraft LLC · Lewes, DEBuilt 1978 · S/N 2169N60LMNb Airplane Inc · Ithaca, NYBuilt 1979 · S/N 61P06197963280N60LRBlake W Preston · Gainesville, FLBuilt 2003 · S/N 929-2003N60LYLeon Roberts Enterprises LLC · Vienna, VABuilt 1965 · S/N 32-10N60MRHansen Charles R · Covington, TNBuilt 1978 · S/N GA-7-0060N60NAHampden Aviation Services Inc · Northampton, MABuilt 1980 · S/N 28-8116049N60NCBalsley Matthew · Rowlett, TXS/N 616N60PLPapa Lima LLC · York, NEBuilt 1967 · S/N 32-870N60PRHarben Grover III · Gainesville, GABuilt 1978 · S/N 60-0490-159N60RGodette James R · Scottsville, NYBuilt 1975 · S/N XP-1N60RBShrode Rafe C · Jewett, TXBuilt 1955 · S/N 22-2761N60RTPaap Patrick · Menifee, CABuilt 1995 · S/N 658-320-402 FBN60SGRichard Amster · Brookline, MABuilt 2011 · S/N 1461-2011N60SSDhone Shridhar · Livermore, CABuilt 1968 · S/N 17257479N60SXDitzler Enterprises Inc · Grinnell, IAS/N 15285148N60TBMoffet Brian · Santa Cruz, CAS/N 502N60UKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2008 · S/N 3006N60UMWbyaa LLC · Saline, MIBuilt 1969 · S/N 28-11347N60UPBrietigam Charles T · Meridian, IDBuilt 2010 · S/N CTB-3N60VWNix William C · Sterling, COBuilt 1996 · S/N 100N60WEVeillon Joseph B · Alexandria, LABuilt 1974 · S/N 352N60WFEngels John · Edmond, OKBuilt 1959 · S/N 24-1635N60WMSmith Ted J · Lakeland, FLBuilt 2000 · S/N 25041N60WRAmbush One LLC · Memphis, TNBuilt 2003 · S/N 24812N60WUWsu Campus Of Applied Sciences And Technology · Wichita, KSBuilt 2025 · S/N 4496615N60WWMorton Ronald S · Seguin, TXBuilt 1996 · S/N 001N60WYCannon Land LLC · Kalispell, MTBuilt 2022 · S/N 3388N60YGLindstrom Dave C · Marinette, WIBuilt 1974 · S/N 17263953N60ZYBrewer Terry P · Oakland, IAS/N 002N6100DSzostak Edward M · San Diego, CABuilt 1956 · S/N 22-4744N6100JFranklin County Flying Club Inc · Turners Falls, MABuilt 1976 · S/N 28-7615302N6100PSuarez-Alicea Jorge A · Enterprise, ALBuilt 1959 · S/N 24-1198N61011Inter American University Of Puerto Rico · Bayamon, PRBuilt 2008 · S/N 2844139N6101DHanson John A · Molena, GABuilt 1957 · S/N 22-4745N6101M316 Aviation LLC · Sandy, ORS/N 7488C
Back to AD 81-18-04 R2