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.

N942TECardinal Enterprise LLC · Jackson, WYBuilt 2003 · S/N 10221N942VTMcintosh Donald W · Sandpoint, IDBuilt 2010 · S/N 942N942WGPotter Mark H · Santa Rosa, CABuilt 2007 · S/N 90013N9430LArnason Matthias J · Portland, ORS/N AA1A-0230N9430NOakley Air LLC · Oakley, MIBuilt 1969 · S/N 28R-35142N9430VRuff Deborah · Auburn, CABuilt 1970 · S/N 700030N9430W3zero Whiskey LLC · Newport Beach, CABuilt 1968 · S/N 28-11136N9431COsgood Air LLC · Ransom, KSBuilt 1978 · S/N 28-7890411N9431JCurrie Kenneth Edward · Lumberton, NCBuilt 1966 · S/N 28-3542N9431LCordova Zachary · Brighton, COS/N AA1A-0231N9431TDavis Gary L · Burleson, TXBuilt 1978 · S/N 38-78A0101N9432DRegistered aircraftBuilt 1984 · S/N 172RG1160N9432LMendelson Edward · Philadelphia, PAS/N AA1B-0032N9433DPacer Flight LLC · Huron, OHBuilt 1958 · S/N 22-6407N9433EKozma Peter · San Diego, CABuilt 1979 · S/N 17272264N9433JSierra Delta Aviation Services Inc · Middletown, DEBuilt 1966 · S/N 28-3545N9433LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276556N9433RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 20608337N9433WSanford William M · Olalla, WABuilt 1968 · S/N 28-11141N9434JSchmidt Matthew F · River Falls, WIBuilt 1966 · S/N 28-3546N9434VKnackstedt Dennis R · Winfield, KSBuilt 1970 · S/N 700046N9434WJohnson James E · Calhoun, LAS/N VE-7711N9435BPalladino Michael A · Pinehurst, NCFirst renewal noticeBuilt 1981 · S/N 172RG0821N9435JHarmon Daniel J · Sheridan, INBuilt 1966 · S/N 28-3547N9435LHubbell Aerin B · Mccordsville, INBuilt 1971 · S/N AA1A-0235N9435NDoran Jeffrey · Centerburg, OHS/N 28R-35148N9435WPace Lawrence W · Westminster, COBuilt 1968 · S/N 28-11145N9436WGiesbrecht Harley L · Deridder, LABuilt 1968 · S/N 28-11153N9437DRichmor Aviation Inc · Scotia, NYBuilt 1984 · S/N 172RG1161N9437JGarba Ibrahim I · Boulder City, NVBuilt 1966 · S/N 28-3549N9437LMurrell George E · Glendale, AZBuilt 1971 · S/N AA1A-0237N9438DWeidner Kevin G · Bunker Hill, ILBuilt 1958 · S/N 22-6412N9438HBering Capital LLC · Anchorage, AKS/N 17266155N9438LM & B Blue Sky LLC · Southlake, TXS/N AA1A-0238N9438VPrestridge Jacob · Portland, ORS/N 700071N94397Koenitzer Judson B · Chetek, WIBuilt 1982 · S/N 15285662N9439BAv Dak Inc · Crystal, NDBuilt 1981 · S/N 172RG0822N9439ESilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1979 · S/N 17272265N9439HTreichler Peter DBA · East Aurora, NYBuilt 1964 · S/N 6N9439KAirspeed Marketing Bravo LLC · Phoenix, AZBuilt 1976 · S/N 28-7625180N9439LCheung Patrick · Boca Raton, FLBuilt 1971 · S/N AA1A-0239N9439WCherokee Ltd LLC · Mesa, AZBuilt 1967 · S/N 28-11151N943CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282406N943GDowning John Brent · Castro Valley, CABuilt 2005 · S/N 30038CN943KSStark James E Trustee · Sun City, AZBuilt 1978 · S/N 17270273N943MAMiller Joseph T IV · Bethel, NCBuilt 2009 · S/N 40663N943NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881922N943RVShea Tim M · Pearland, TXBuilt 1993 · S/N JB 2644N943SASunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15279675N943SPLittle Airplanes LLC · Aurora, ORBuilt 1999 · S/N 172S8138
Back to AD 81-18-04 R2