OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,720

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.

N2146TBreitfelder Nicholas A · Durango, IABuilt 1971 · S/N 28-7125546N2146XGalloway Robert L III · Cypress, TXBuilt 1997 · S/N 24-3413N21471Gourley Adam C · La Porte, INBuilt 2000 · S/N 3426N2147AHosmer Richard Alan · Cedartown, GABuilt 1952 · S/N 22-578N2147DRegistered aircraftBuilt 1978 · S/N 28-7911034N2147GAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 28-7916178N2147KAgati Inc · Chicago, ILBuilt 1978 · S/N 32-7940020N2147NN701bt LLC · Carmel, INBuilt 1979 · S/N 32-7940035N2147PStevens Nicholas · Fort Collins, COBuilt 1979 · S/N 32-7940042N2147TSchavone Loren A · Fullerton, CABuilt 1971 · S/N 28-7125547N2147WMeyer Ronnie G · Sidney, NEBuilt 1974 · S/N M-1520N21481Houston Christopher T · Webster, NYBuilt 1978 · S/N 28-7916044N21483Lima-001 LLC · Muscatine, IABuilt 2003 · S/N 172S9515N21485Dipzinski Victor L · Clio, MIFirst renewal noticeBuilt 1974 · S/N 17263956N21489D & S Aviation LLC · Spring, TXBuilt 1978 · S/N 28-7990050N2148FRegistration Pending · Wilmington, DERegistration pendingBuilt 1978 · S/N 44-7995157N2148N2 Delta 5 LLC · Oakes, NDBuilt 1979 · S/N 32R-7985069N2148PHorizon Aviation LLC · Buffalo, NYBuilt 1979 · S/N 32-7940043N2148QMorten Jesse L · Larimore, NDBuilt 1974 · S/N 177RG0548N2148ZMalburg Phillip E · Holland, MIBuilt 1979 · S/N 28-7916378N2149DSeaton Brad S · Cache, OKBuilt 1978 · S/N 32R-7985031N2149EPierce Martin H · Big Sky, MTBuilt 1978 · S/N 28-7911044N2149JN2149j LLC · Colorado Springs, COBuilt 1978 · S/N 28-7911061N2149QRegistered aircraftBuilt 1974 · S/N 177RG0549N2149TChandler Air Service Inc · Chandler, AZBuilt 1979 · S/N 28-7911114N214APikago LLC · Moreno Valley, CABuilt 1978 · S/N 17270830N214AALewis University · Romeoville, ILS/N 28-4735N214ACRicard Carter J · Albany, MNBuilt 2000 · S/N 1305-2000N214BKS&N Pearl LLC · Port Orange, FLBuilt 2021 · S/N 18283138N214BWKansas Farm & Ranch Inc · Seneca, KSBuilt 1994 · S/N 1202-94N214CMeister Curtis E · Plover, WIBuilt 1998 · S/N 1430N214CALester Don · Campton, NHBuilt 1974 · S/N 28R-7435281N214CMKentucky Fly Boys Aviation LLC · Vine Grove, KYBuilt 1978 · S/N 372-78N214DPRothhaar Paul M · Yorktown, VABuilt 1985 · S/N 38N214DXDixon Craig M · La Grande, ORBuilt 2013 · S/N 91863N214EDWoods Johnny I · Hendersonville, TNBuilt 1980 · S/N 44-8195007N214ERLima-001 LLC · Muscatine, IAS/N 17263480N214FAGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281214N214GCCloud Robert Trustee · Kerrville, TXBuilt 2024 · S/N 18283286N214GPPietsch Warren A · Minot, NDBuilt 1994 · S/N Z1A-0016N214GSStephens Mark · Cullman, ALBuilt 1972 · S/N 28-7205138N214GTAcba Inc Trustee · Wilmington, DEBuilt 2003 · S/N 2214N214GZAerospring Leasing LLC · Wasilla, AKBuilt 2005 · S/N 172S9862N214HRSchaetzel Paul · New Meadows, IDBuilt 2025 · S/N 345N214JADer Aviation LLC · Dover, TNS/N 3122N214JC214 Mooney LLC · Boca Raton, FLBuilt 1978 · S/N 24-0706N214JDMilngavie LLC · Plano, TXBuilt 2006 · S/N 20416N214JNFox-1 Drafting & Design Inc · Eagan, MNBuilt 1966 · S/N 30-1130N214JPTop Flight Leasing LLC · Frankfort, ILBuilt 1994 · S/N 3213083N214LE3 Weens LLC · Hoschton, GABuilt 2004 · S/N 18281416
Back to AD 81-18-04 R2