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.

N757EHWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279677N757ENMontana Flying Service LLC · Missoula, MTBuilt 1977 · S/N 15279682N757EUB2b Services LLC · Lincoln, CAS/N R18201222N757EVRoth Michael L · Lanse, MIBuilt 1977 · S/N 15279689N757EWMagin Sonny K · Harvest, ALS/N 15279690N757EXRound Engine Aero · Nashville, MIS/N 15279691N757EZXtratech Corp · Davie, FLBuilt 1979 · S/N R18201223N757FCBoland Matthew S · Anchorage, AKBuilt 1977 · S/N 15279696N757FDR&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 15279697N757FEMock Joseph R · Huntsville, TXBuilt 1977 · S/N 15279698N757FFAir-Planes LLC · Soddy Daisy, TNS/N 15279699N757FHSilverman Mitchell G · Cumberland, RIBuilt 1977 · S/N 15279701N757FJGeorge Alexander Vasil Jr · Haverhill, MABuilt 1977 · S/N 15279702N757FQMundis William L · York, PABuilt 1977 · S/N 15279708N757GEEllis Wendel K · Chugiak, AKBuilt 2026 · S/N 4N757GNExecutive Wings LLC · Bolivar, TNBuilt 1977 · S/N 15279730N757GQAngel Aviation Inc · Peoria, AZBuilt 1977 · S/N 15279732N757GTGolf Tango LLC · Lubbock, TXBuilt 1979 · S/N R18201229N757GXWinging It Aviation Two LLC · Gulf Shores, ALBuilt 1977 · S/N 15279739N757HAKim Sungtae · Fort Worth, TXS/N 15279742N757HCBaker David L · Leavenworth, KSBuilt 1977 · S/N 15279744N757HERussell Robert Q · Genoa City, WIBuilt 1977 · S/N 15279746N757HFG & T Associates · Bellevue, WABuilt 1979 · S/N R18201232N757HHA&R Aero LLC · Sacramento, CAS/N 15279749N757HMSchmitt Rudy · Brookshire, TXS/N 15279753N757HRJohnson Gregory D · Lakeside, CAS/N 4218N757HSRindlisbaker Chad · Pocatello, IDBuilt 1979 · S/N R18201234N757HTParrish Aviation Flight Academy LLC · Southlake, TXS/N 15279759N757HVPropel Air LLC · Pottstown, PABuilt 1977 · S/N 15279761N757HXAppalachian Aviation LLC · Harrisonburg, VABuilt 1977 · S/N 15279763N757HYWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279764N757JBBrilhart John G · Higbee, MOBuilt 2021 · S/N 74128N757JDSuburban Air Corp · Castro Valley, CABuilt 1977 · S/N 15279769N757JFBoykin Randy K · Aguila, AZBuilt 1979 · S/N R18201236N757JGJet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15279772N757JJJetstream Aeronautics LLC · San Antonio, TXBuilt 1977 · S/N 15279774N757JKMcdermotts Letsfly LLC · Somerton, AZBuilt 1977 · S/N 15279775N757JLPalmer Travis S · Maupin, ORBuilt 1979 · S/N R18201237N757JWTary John G · Redondo Beach, CABuilt 1979 · S/N R18201238N757JXHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279787N757JYBreuer Lisa M · Horseshoe Bend, IDBuilt 1977 · S/N 15279788N757KFBob Hoover Academy · Salinas, CABuilt 1977 · S/N 15279795N757KMClover Park Technical College · Tacoma, WABuilt 1977 · S/N 15279801N757KPPhill-Air Inc · Dover, DEBuilt 1978 · S/N 28-7816616N757KXDamian Davis Construction Co · Candler, NCBuilt 1977 · S/N 15279811N757LKloss Todd T · San Antonio, TXBuilt 1998 · S/N 24844N757LBSwaney Brian W · Pendleton, SCBuilt 1977 · S/N 15279815N757LELake Elmo Aero LLC · Lake Elmo, MNS/N 17266022N757LGMamet Oren · Andover, MABuilt 1977 · S/N 15279820N757LHWoldow Frederic A · Morton, ILBuilt 2003 · S/N 81279
Back to AD 81-18-04 R2