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.

N7578TPhysics Aviation LLC · Jonesboro, ARS/N R18200041N7578VWillis Daniel M · Shelbyville, TNBuilt 1976 · S/N 177RG0869N7578WWeakley Enterprise LLC · Ashland City, TNS/N 28-1476N7578ZSilent Flight LLC · Payette, IDBuilt 1965 · S/N 25-3651N75790Kempton Larry G · Grand Junction, COBuilt 1976 · S/N 17267950N75791D L S Aviation Services Inc · Wilmington, DEBuilt 1976 · S/N 17267951N75793Miami Valley Career Technology Center · Clayton, OHBuilt 1976 · S/N 17267953N75794Appleton Scott · Cunningham, TNFirst renewal noticeBuilt 1976 · S/N 17267954N75795Harrison Mark A · Corpus Christi, TXS/N 17267955N75797Eralet Inc · Middletown, DEBuilt 1976 · S/N 17267957N75799Ocean Breeze Aviation Inc · Hollywood, FLBuilt 1976 · S/N 17267959N7579DNutter Teri L · Glennallen, AKBuilt 1957 · S/N 18-5867N7579HDolansky Edwin J · Youngstown, NYBuilt 1946 · S/N 12-454N7579VSteenson James H Jr · Hudson, NHBuilt 1976 · S/N 177RG0870N7579WAll For Yu Consulting Corp · Macon, GABuilt 1964 · S/N 28-1515N7579ZRotor And Wing · Tioga, NDBuilt 1965 · S/N 25-3653N757AAHeavy Metal Air LLC · Farmingdale, NYBuilt 1977 · S/N 15279575N757ABCallum James M · Newport, NHBuilt 1977 · S/N 15279576N757ACLewis Aviation Inc · Wilmington, DEBuilt 1998 · S/N 809-98N757ADLong Island Aviators LLC · Seaford, NYBuilt 1977 · S/N 15279578N757AHRed Sky Aviation LLC · Livermore, CABuilt 1977 · S/N 15279582N757AJSunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15279583N757AKSloan Kyle C · Anchorage, AKBuilt 1950 · S/N 18-278N757APMcnamara William T · Memphis, TNBuilt 1972 · S/N MC-122N757AYAdams Steve G · Watsonville, CABuilt 1977 · S/N 15279597N757AZKilo Aviation LLC · East Peoria, ILS/N 15279598N757BBarber Shoppe Inc DBA · Cameron Park, CABuilt 1965 · S/N 2883N757BBKelley Aircraft LLC · Weyers Cave, VABuilt 1977 · S/N 15279600N757BFOld Goat LLC · Wilmington, DEBuilt 1977 · S/N 15279604N757BGWallace Wayne W · Bristol, CTBuilt 1979 · S/N R18201267N757BKPfister Mark A · Acworth, GABuilt 1977 · S/N 15279608N757BPCommins Alfred D · Friday Harbor, WABuilt 1979 · S/N R18201214N757BS4 One Air LLC · Holland, MIBuilt 1977 · S/N 15279615N757BVPlayer Dennis M · Union Bridge, MDS/N 15279618N757BWK2 Sales LLC · Idaho Falls, IDS/N 15279619N757CSwasey Brian Paul · Woodland, CABuilt 2000 · S/N 5259N757CG4g Family LLC · Dover, DEBuilt 2021 · S/N 3381N757CQPorter Casey · Bluffton, SCBuilt 1977 · S/N 15279636N757CSBowers Scott · Mc Donald, PABuilt 1977 · S/N 15279638N757CTAero Fliers LLC · Kalispell, MTBuilt 1977 · S/N 15279639N757DAHuston Wes · Sanger, TXBuilt 1977 · S/N 15279646N757DCLeon Hinkle LLC · Fort Ashby, WVBuilt 1979 · S/N R18201217N757DEMavity Michael D · Phoenix, AZBuilt 1977 · S/N 15279650N757DFWisener Lupita A · Mineola, TXBuilt 1977 · S/N 15279651N757DGHall Wesley W Trustee · Reno, NVBuilt 1979 · S/N R18201218N757DKKickbush David L · Guttenberg, IABuilt 2013 · S/N 73034N757DLRegistered aircraftBuilt 1964 · S/N 399N757DQIowa Great Lakes Flyers Inc · Cheyenne, WYBuilt 1977 · S/N 15279660N757DSCummings Scott A · Monitor, WABuilt 1947 · S/N 12-2745N757DTStar City Aviation Inc · Roanoke, VAS/N 15279663
Back to AD 81-18-04 R2