OpenAirDocs.org
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.

N5208ZArnold Tyler S · Montgomery, LAS/N 22-8878N52090Bradley Flying Assoc · Peoria, ILBuilt 1980 · S/N 17274409N52093Helgeson Jeffrey D · Colonia, NJFirst renewal noticeBuilt 1977 · S/N 177RG1168N5209HCook James F · Portland, ORBuilt 1949 · S/N 16-11N5209LKing Christian T · Rhinelander, WIBuilt 1967 · S/N 28-4501N5209RGuyer Kasey A · Billings, MTBuilt 1974 · S/N 17263426N5209VHawkbill Aviation LLC · Hudson, NCBuilt 1980 · S/N 172RG0470N5209WBeck Richard C · Wellington, ALBuilt 1961 · S/N 28-245N520AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2021 · S/N 28020049N520AZSaydun LLC · Richardson, TXBuilt 1966 · S/N 27-3424N520BBJ S Aviation Corp · Farmingdale, NYBuilt 2006 · S/N 2842257N520BNHyannis Air Service Inc · Hyannis, MABuilt 1991 · S/N 2240N520BSHanshew James M · Phoenix, AZBuilt 2004 · S/N 81255N520BWWheadon William J · Napa, CABuilt 2019 · S/N 2045N520CAGruia Alin · Beaverton, ORBuilt 1977 · S/N 13187N520CWCentral Washington University · Ellensburg, WABuilt 2017 · S/N 2843921N520DRDmgf LLC · Bertram, TXBuilt 1961 · S/N 1116-66N520EPMiles In The Sky LLC · Springfield, MOBuilt 2010 · S/N 18282274N520FLSiry Kristina · Mertztown, PABuilt 1971 · S/N 28-7125345N520HKirsch Kenneth L · Carneys Point, NJBuilt 1975 · S/N 325N520KSH2 Link Company · Lewes, DEBuilt 2004 · S/N 172S9734N520KTTroendle Adam J · Dexter, MNBuilt 2026 · S/N 4931N520LHH2 Link Co · Lewes, DEBuilt 2004 · S/N 172S9731N520LPDpanthera LLC · Salem, ORBuilt 2024 · S/N PX1520031N520LWPaddock Levi J · Springfield, ORBuilt 2017 · S/N 41150N520MAL3 Wolfpack Sigma LLC · Lenexa, KSBuilt 1996 · S/N 32-46020N520MSH2 Link Co · Chino, CABuilt 2006 · S/N 4496230N520PBoggs Kevin D · Washington, PABuilt 2006 · S/N 70798N520PLRdp Aviation LLC · Gig Harbor, WABuilt 2005 · S/N 172S9887N520PPAdams Shannon I · Punta Gorda, FLBuilt 2011 · S/N 3140N520QLFroehlich Lawrence F · Melville, NYBuilt 2015 · S/N 72069N520RRRauch Richard B · Wilsonville, ORBuilt 2003 · S/N 81485N520TXWalker Ronald J · Cedar Park, TXBuilt 2004 · S/N 71269N520UTecnam U S Inc · Sebring, FLBuilt 2022 · S/N 205/USN520VTPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N 1001N520WBVan Bortel Aircraft Inc · Arlington, TXBuilt 2008 · S/N 18282049N520XSwaz Aviation LLC · Mesa, AZBuilt 1978 · S/N 28-7816582N52100Delta State University · Cleveland, MSBuilt 1980 · S/N 17274412N52101Defontes Kenneth W Jr · Kingsville, MDS/N 177RG1170N52106Simmons Aviation Services LLC · Pawcatuck, CTBuilt 1980 · S/N 17274413N5210AChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9118N5210FSloan Nathan S · Owensboro, KYBuilt 1979 · S/N 17273128N5210LDewilde Lee Ray · Huslia, AKBuilt 1967 · S/N 28-4502N5210QFortress Group LLC · Thompsons Station, TNBuilt 2002 · S/N 18281140N5210RPrince Steven S · Westerly, RIBuilt 1974 · S/N 17263427N5210T51st Aero Squadron LLC · Hoover, ALBuilt 1972 · S/N 28R-7235195N5211Dacy Julia A · Harvard, ILBuilt 1967 · S/N M-1N52119Big E LLC · Lemoore, CAS/N 17274418N5211LDuncan Timothy Scott · Sioux Falls, SDBuilt 1967 · S/N 28-4503N5211MSinger Seth · Suffern, NYBuilt 1973 · S/N 17262585
Back to AD 81-18-04 R2