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.

N15PJBreedlove Ernest Dale · Valley Mills, TXBuilt 1999 · S/N 23313N15PQUsda Aphis Ws Atoc · Cedar City, UTBuilt 2010 · S/N CC18-0043N15PTThyssen Patrick L · Conroe, TXBuilt 2009 · S/N 40257N15QAQuiet Aero LLC · Fort Myers, FLBuilt 1960 · S/N 24-2388N15RAAviation Career Enrichment Inc · Atlanta, GABuilt 1970 · S/N 17259568N15RMFlying Y Farms LLC · Klamath Falls, ORBuilt 1969 · S/N 18-8814N15RVCrawford Larry G · California, MOS/N 298N15SEWilliams Paul E · Kendallville, INBuilt 2005 · S/N 1386-2005N15SWNi Oliver Xingyuan · Norfolk, VABuilt 1968 · S/N 17256875N15SZZurcher Susan R · Hampshire, ILBuilt 2022 · S/N 18283202N15TKSpence William D · Waller, TXBuilt 1988 · S/N 1N15TPSmith Richard R · Austin, TXBuilt 2006 · S/N 1990N15TSSchell Timothy N · Dubois, WYBuilt 1996 · S/N 23802N15TYArneson Kenneth W · Beaverton, ORBuilt 1975 · S/N 150-76713N15USale Reported · Van Nuys, CASale reportedBuilt 1979 · S/N ME-160N15VRCarley Daniel · Center Moriches, NYBuilt 1998 · S/N 21486N15WJFleming Laurence Erik · Salinas, CABuilt 1999 · S/N 824-99N15WVWhiskey Victor Aviation LLC · Fairmont, WVBuilt 1969 · S/N 667N15XXDalks Leasing Inc · Wilmington, DEBuilt 1951 · S/N 18-811N15YMMiller Jeff A · Deering, NHBuilt 1996 · S/N 168N1600RColeman Daniel L · Chattanooga, TNBuilt 1974 · S/N AA5-0700N1600UOsprey Holding Company LLC · Foley, ALBuilt 2005 · S/N 172S9905N1601Moretti Warren R · Petaluma, CABuilt 2004 · S/N 20588N16019Brown Kenneth D · Port Murray, NJS/N 17702478N1601SRussell Bryan E · Joshua, TXS/N 28-7790057N16021Hill Allen W · La Junta, COBuilt 1976 · S/N 17702479N16023Carr Richard D Trustee · Stockton, MOBuilt 1976 · S/N 17702480N1602ABent James L Jr DBA · Palatine Bridge, NYS/N 18-1240N1602BBoyd Aaron · S San Fran, CABuilt 1979 · S/N 17272737N1602GHenry Thomas J · Ellicott City, MDBuilt 1968 · S/N 613N1602PDavis Jacob J · Georgetown, TXBuilt 1954 · S/N 22-2417N1602VRegistration Pending · Lucas, TXRegistration pendingBuilt 1974 · S/N 17263690N1603EWright Michael A · Advance, NCBuilt 1978 · S/N 17271062N1603GCp Aviation Inc · Santa Paula, CABuilt 1968 · S/N 609N1604AFredericks Elmo J · Mandaree, NDBuilt 1951 · S/N 18-1242N1604GMut Henry · Brookshire, TXBuilt 1968 · S/N 101N1605GAllen Matthew C · Pomona, CABuilt 1968 · S/N 99N1605RGeiger Emory H Jr · Snellville, GABuilt 1976 · S/N AA1B-0605N16066Thompson Derek D Jr · Dunkirk, MDBuilt 1976 · S/N 17702482N1606AFilkill David B · Willow, AKBuilt 1951 · S/N 18-1246N1606GNigri David A · Smithfield, RIBuilt 1968 · S/N 112N1606RStansel Jon S · Conway, ARBuilt 1976 · S/N AA1B-0606N1607HHanson Jeffrey L · Fuquay Varina, NCBuilt 1975 · S/N 177RG0780N1607REash Neal S · Louisville, TNBuilt 1976 · S/N AA1B-0607N1608GDrexler William G · Peyton, COBuilt 1968 · S/N 105N1608SNew Horizon Aviation Inc · Warwick, RIBuilt 2005 · S/N 172S9907N1609EEilenfeld Teresa · Mansfield, OHBuilt 1978 · S/N 17271065N1609RJohnson Henry D · Buena Park, CABuilt 1976 · S/N AA1B-0609N160AASauerbrey Andreas M · Steamboat Springs, COBuilt 2007 · S/N 2391N160BAHitec Construction Services Inc · Lincoln, CABuilt 2002 · S/N 46M
Back to AD 81-18-04 R2