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.

N9351JCoyote Flight Centers LLC · Amarillo, TXBuilt 1966 · S/N 28-3449N9351LPiciullo Lenny R · Folsom, CAS/N AA1A-0051N9351MKempa Jesse R · Santa Cruz, CABuilt 1966 · S/N 1253N9351SHauling Ag Inc · Middlebury, INBuilt 1975 · S/N MB-769N9351TBenson Michael W · Julesburg, COBuilt 1978 · S/N 38-78A0063N9351VCaldararu Andrei H · Madison, WIBuilt 1969 · S/N 700008N9351WWurmbrand Stephan B · Westhampton, MABuilt 1968 · S/N 28-11103N93521Quitter John F · Galt, CABuilt 1993 · S/N 2376N93526Delta State University · Cleveland, MSBuilt 1982 · S/N 15285507N93529Richmor Aviation Inc · Hudson, NYBuilt 1982 · S/N 15285510N9352JDiorio Robert A · Redlands, CABuilt 1966 · S/N 28-3450N9352WNistler Anthony Lamar · Mcgregor, MNBuilt 1968 · S/N 28-11040N9353DRegistration Pending · Simi Valley, CARegistration pending, canceledBuilt 1982 · S/N 172RG1131N9353JNychka Robert J · Wills Point, TXBuilt 1966 · S/N 28-3451N9353MBarnett Zachary P · Paducah, KYBuilt 1966 · S/N 1285N9353RStephanian Erick Trustee · Naples, FLFirst renewal noticeBuilt 1978 · S/N R18200695N9353VLangholz Denise M · Covington, WABuilt 1969 · S/N 700011N9354JLamb David S · Yuba City, CABuilt 1966 · S/N 28-3453N9354LElliott Brevyn · Marinette, WIS/N AA1A-0054N9354MFresh Air Properties LLC · Hayesville, NCBuilt 1966 · S/N 1286N9354SLinda Ann Trust LLC · Dover, DES/N M-1654N9354VPinckney Robert L · Elgin, SCBuilt 1969 · S/N 700009N9354WBlue Horizon Aircraft LLC · Wilmington, DEBuilt 1968 · S/N 28-11042N93550Flight School Of Gwinnett Inc · Lawrenceville, GABuilt 1982 · S/N 15285513N9355DHarris Chet A · Anchorage, AKS/N 18-6616N9355SBestway Pilot Car LLC DBA · Metropolis, ILBuilt 1975 · S/N M-1656N9355WEngland Noah C III · Lowell, NCBuilt 1968 · S/N 28-11043N9356DHammond Dwight L · Burns, ORS/N 18-6617N9356HQuad Cities Aero LLC · Bettendorf, IABuilt 1975 · S/N 17266113N9356JVali Air Service LLC · Livingston, MTBuilt 1966 · S/N 28-3455N9356LCallaway Jonathan L · Van Alstyne, TXS/N AA1A-0170N9356MRegistered aircraftBuilt 1966 · S/N 1288N9356RQuality By Design Inc · Leesburg, FLBuilt 1978 · S/N R18200696N9356SHeman Christopher M · Lees Summit, MOBuilt 1975 · S/N M-1657N9356VWilson Willard L · Daphne, ALBuilt 1969 · S/N 700009N9356WOrtman Stephen B · Mill Creek, WABuilt 1968 · S/N 28-11045N9357DLeary Patrick W DBA · Lewistown, MTBuilt 1958 · S/N 18-6618N9357JKirchoff Jennifer L · Hamden, CTBuilt 1966 · S/N 28-3456N9357MSpencer Jared · Mandeville, LABuilt 1966 · S/N 1289N9357PNewman Joseph G · Grand Ledge, MIBuilt 1960 · S/N 24-2033N9357SWeiser Denis P · Osceola, IABuilt 1975 · S/N MC-354N9357VWise Christopher J · Plano, TXBuilt 1969 · S/N 700013N93585Sipher William M · Baker, FLBuilt 1982 · S/N 15285521N9358CMiloud Chadd K · Fort Worth, TXBuilt 1978 · S/N 28-7816466N9358ELechmanski Philip J · Shelter Island, NYBuilt 1979 · S/N 17272236N9358LUnited States Air Force · Eglin Afb, FLBuilt 1986 · S/N 17276546N9358SAnderson Justin T · Franklin, OHBuilt 1975 · S/N M-1658N9358TPitts Lynn Larry · Webb City, MOBuilt 1978 · S/N 38-78A0066N9358VEickman Jaret · Scottsdale, AZBuilt 1969 · S/N 700014N9358WPena Evan M · San Antonio, TXS/N 28-11047
Back to AD 81-18-04 R2