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.

N92789N5746u LLC · Dover, DES/N 17261619N9278JMcbride Gary J · Niantic, CTBuilt 1966 · S/N 28-3357N9278MIlya Sevrugin · Santa Clarita, CABuilt 1966 · S/N 1215N9278SSpeed Kenneth W · Redington Shores, FLBuilt 1976 · S/N M-1765N9278TSanderson Nicholas DBA · Olivet, MIBuilt 1978 · S/N 38-78A0314N9278WN9278w LLC · Corona, CABuilt 1967 · S/N 28-10952N92790Smith Aviation LLC · Springer, OKBuilt 1946 · S/N 12-236N92792Arton Brad D · Prairieville, LABuilt 1946 · S/N 12-238N92793Mikkelsen Caleb M · Wasilla, AKBuilt 1946 · S/N 12-239N92794Sanoski Gregory · Talkeetna, AKBuilt 1946 · S/N 12-240N9279DAcw Aviation LLC · Hines, ORS/N 18-6582N9279JAndromeda Air LLC · Houston, TXBuilt 1997 · S/N 2843068N927ASZlotnick Quincy J P A · Sebastopol, CABuilt 1981 · S/N 927N927AZN927az LLC · Miami, FLBuilt 2002 · S/N 172S9090N927BBN927bb LLC · Hilton Head Island, SCBuilt 2021 · S/N 71595N927CLMcdaniels Scott R · Hubbard, ORBuilt 2004 · S/N 1N927CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8915N927DDMcallister Paul · Delafield, WIBuilt 2016 · S/N GP4-438N927DRButts John C · Ukiah, CABuilt 2010 · S/N 82849N927ELEmerald City Aircraft Leasing Inc · Port Orchard, WAS/N 2554N927GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881075N927GHB R S Leasing Inc · Wilmington, DEBuilt 2005 · S/N 172S10024N927GPChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12409N927GSGina Bakiares Santori Dpm LLC · Lisle, ILFirst renewal noticeBuilt 2000 · S/N 30019CN927JEEdwards James C · Dayton, WABuilt 2024 · S/N 007N927JSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 18-7609143N927KRCandace A Larned Enterprises Inc · Long Beach, CABuilt 1973 · S/N 28R-7335156N927MPPrebish Matthew · Heath, TXBuilt 1980 · S/N R18201569N927PADuncan Michael J · Danville, VABuilt 1977 · S/N 28-7716082N927RJWright Bruce M · Rosharon, TXBuilt 2013 · S/N 82360N927SANpg Group LLC · Missoula, MTBuilt 2003 · S/N 927-2003N927SUOhio State University · Columbus, OHBuilt 2021 · S/N 4496528N927TBAlpha Mike LLC · Stoughton, MABuilt 2006 · S/N 2364N927TCWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264152N927TGStacy David D · Chugiak, AKBuilt 1946 · S/N 12-182N927TMGmr Leasing LLC · Lincoln, DES/N 28-21102N927TSM & G Aircraft Management LLC · Aurora, ORBuilt 2023 · S/N 172S13067N927WCalabrese Joseph Jr · Winamac, INBuilt 1979 · S/N M-2258N927WTHaugen Delos L · Burlington, NDBuilt 1966 · S/N 438N9280AApm Leasing LLC · Casper, WYBuilt 1985 · S/N 28-8616040N9280JLone Star Steel Structures LLC · Kaufman, TXS/N 28-3359N9280LFennig Richard L · Virginia Beach, VABuilt 1971 · S/N AA1A-0180N9280MRiley Dean A · Friday Harbor, WABuilt 1972 · S/N 17260490N9280TChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12413N9280VReifel Harry C Jr · Boxford, MABuilt 1969 · S/N 690065N9280WWhiskey Charlie Aviation LLC · Reno, NVBuilt 1967 · S/N 28-10954N92810Dilse Brian R · Grand Forks, NDBuilt 1973 · S/N 17261626N92817Millner James W Sr · Soldotna, AKBuilt 1973 · S/N 17261628N9281ABuiqui Aerospace Corp · Kissimmee, FLBuilt 2022 · S/N 172S12787N9281EShannon Randal · Drexel, MOS/N 7155C
Back to AD 81-18-04 R2