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.

N63CVClark Terry L · Bartlesville, OKBuilt 1979 · S/N 386-79N63DABass Lake Aviation LLC · Webster, WIBuilt 1998 · S/N 1238-98N63DGMiller Colette L · Sequim, WAS/N 637N63DMDurbin Hal E · Findlay, OHBuilt 1981 · S/N DM2N63DTTanona Duane T · Enumclaw, WABuilt 1998 · S/N 23762N63EDRosinbaum Daryl A · Waller, TXBuilt 2024 · S/N 63N63EZWorley Dan L · Heber Springs, ARS/N 1109N63FEFour Macs Logistics LLC · Houlka, MSBuilt 1992 · S/N 1225N63FHRegistered aircraftBuilt 2004 · S/N 60498N63FKHawley Robert W · Fort Worth, TXBuilt 1962 · S/N 28-757N63GOneil Liam Trustee · Vashon, WABuilt 1972 · S/N 17260616N63GKRawareo LLC · Warsaw, MOS/N 28-20781N63GMBmi Aviation LLC · Hallandale Beach, FLBuilt 1990 · S/N 24-3182N63GSAerial Surveys Inc · Dover, DEBuilt 2002 · S/N 5218N63HALmn Aircraft Leasing LLC · Sellersburg, INBuilt 2021 · S/N 1198-2022N63HESkoog Rodney D · White Bear Lake, MNBuilt 2004 · S/N 452-2004N63HYTailwheel Pilots LLC · Lacon, ILBuilt 2001 · S/N 2173N63JAWings Over Texas Holdings LLC · Denton, TXBuilt 2007 · S/N 172S10484N63JDD'Angelo Joseph P · Callicoon Center, NYBuilt 1979 · S/N 17272940N63JWRegistered aircraftBuilt 1977 · S/N 18-7709139N63KBBeene Kenneth E · Waco, TXBuilt 2006 · S/N 2460N63LDKnudsen Allan L · Council Bluffs, IABuilt 2008 · S/N 60383N63LUChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280591N63MKPeterson Grant · Mclean, VABuilt 2000 · S/N 20-0051N63MMNzere Michael · Crowley, TXBuilt 1963 · S/N 2569N63MSSire Daniel T · Wausau, WIBuilt 2005 · S/N 90768N63MTGriffith Gary L · Palestine, TXBuilt 1962 · S/N M-97N63MYRegistered aircraftBuilt 2008 · S/N 10692008N63PEGoodinson Marc D · Hamburg, NJBuilt 1968 · S/N 28R-30908N63PKRegistered aircraftBuilt 1965 · S/N 734N63PLBoeing Employees Flying Club St Louis Inc · Saint Louis, MOBuilt 1977 · S/N 28-7816263N63PNDga Aviation LLC · Sacramento, CABuilt 2010 · S/N 80835N63PVAir Tech Flying Club Inc · Chesterfield, VABuilt 1994 · S/N 3213087N63RMclenaghan Alvin N · Phoenix, AZBuilt 1965 · S/N 858N63RH4-D Aviation Consulting LLC · Wilmington, DES/N 60494N63RLVolland Aimee C · Tavernier, FLBuilt 1976 · S/N 28R-7635368N63RWSmith Jacques F · Anchorage, AKBuilt 1978 · S/N 15280763N63SASky View Aviation LLC · Lenoir, NCBuilt 1973 · S/N 17261610N63SMMoore George L · Spring Hill, KSBuilt 1986 · S/N 63N63SPGraves Klaric Carl · Fate, TXBuilt 2020 · S/N 41898N63TXKilly James · Littleton, COBuilt 1991 · S/N 20360N63UDAlf Ix LLC · Chicago, ILBuilt 2017 · S/N 172S12090N63VLPulsar Investments Inc · Scottsdale, AZBuilt 2008 · S/N 91258N63WALariscey Adam · Lyons, GABuilt 2002 · S/N 001N63WFThompson Kevin J · Three Rivers, CAS/N 1136N63WMSmith Russell M · Bokeelia, FLBuilt 1996 · S/N 114N63WPRenno Aero LLC · Ann Arbor, MIBuilt 2005 · S/N 40.498N63WTRodencal Richard · Wisconsin Rapids, WIBuilt 1998 · S/N 404-98N64001Alpha One Aviation LLC · Corona, NYBuilt 1975 · S/N 17264949N64007Baugh Tommye R · Star City, ARBuilt 1975 · S/N 17264955
Back to AD 81-18-04 R2