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.

N886THMock Joseph R · Huntsville, TXBuilt 1974 · S/N 142-74N886TVNault Thomas R · Mojave, CABuilt 2021 · S/N 001N886ZJohn Galt LLC · Fairbanks, AKBuilt 2022 · S/N 4135CN8870CRegistration Pending · Canal Fulton, OHRegistration pendingBuilt 1953 · S/N 22-1479N8870DHaumschild Edward E · Marana, AZBuilt 1958 · S/N 22-6044N8870EGriffin Robert B · Middletown, DEBuilt 1976 · S/N 28-7610089N8870JAsel LLC · North Charleston, SCS/N 28-2842N8870NRiley Dennis M · Surry, MEBuilt 1969 · S/N 28-25732N8871CPlane Fun Inc Tr Trustee · Snellville, GABuilt 1953 · S/N 22-1484N8871DSmith James A · Lyle, WABuilt 1958 · S/N 22-6045N8871FGarvey Michael · Leesville, SCBuilt 1963 · S/N 0235N8871JJohnson Richard E · Mulberry, FLBuilt 1965 · S/N 28-2843N8871NCramer Michael L · Rockville Centre, NYBuilt 1969 · S/N 28-25733N8871PMq Flights LLC · Missoula, MTBuilt 1965 · S/N 24-4328N8871WGutierrez Alajandro · Madison, MSBuilt 1964 · S/N 28-10428N8872CGibbs John D · Victoria, TXBuilt 1953 · S/N 20-1024N8872DJohnson Robert M · Ada, MNBuilt 1958 · S/N 22-6046N8872FCameron William Douglas Jr · Lexington, VAS/N 63-0238N8872GN8872g Holdings LLC · Nashville, TNBuilt 1966 · S/N 15062972N8872JPriority Aviation LLC · Lewes, DES/N 28-2844N8873CGibbs John D · Victoria, TXBuilt 1953 · S/N 20-1023N8873DWroe Daniel C · Denton, MDBuilt 1958 · S/N 22-6047N8873WGarza Reynaldo E · Corpus Christi, TXS/N 28-10430N8874CPleasant Valley Aviation Inc · Bellefonte, PABuilt 1976 · S/N 28-7625135N8874JMelland Curtis B · Hazen, NDBuilt 1965 · S/N 28-2847N8874NFisher Tim A · Stockton, MDBuilt 1969 · S/N 28-25737N8874PWiebe Aron · Seminole, TXS/N 24-4331N8875DBishop Bill I · Cross Plains, TXBuilt 1958 · S/N 22-6049N8875LMorris Michael · Sarasota, FLBuilt 1974 · S/N AA1B-0375N8875NMcclendon Charles Dowel · Lynchburg, VABuilt 1969 · S/N 28-25738N8875WBryan Greg · Oelwein, IABuilt 1964 · S/N 28-10432N8876JDestination Flyer LLC · Memphis, TNBuilt 1965 · S/N 28-2848N8876LDirks Steven J · Cedar Rapids, IAS/N AA1B-0376N8876MLohman Curtis · Shelby, MIBuilt 1964 · S/N M-618N8876PWentworth Douglas G · Simpsonville, KYS/N 244333N8876VBlackburn Aviation Air LLC · Mesa, AZS/N 32-50N8876YComanche 76y LLC · Waynesboro, VAS/N 39-32N8877CBall Fred · College Place, WABuilt 1953 · S/N 20-1025N8877DSale Reported · Crystal, MNSale reportedBuilt 1958 · S/N 22-6051N8877EParrot Flying LLC · San Francisco, CABuilt 1976 · S/N 28-7625162N8877LGuerra Michael J · Fairhaven, MABuilt 1974 · S/N AA1B-0377N8877WAvery Aviation LLC · Picabo, IDBuilt 1964 · S/N 28-10434N8877YVanhook Orville Richard · Somerset, KYBuilt 1970 · S/N 39-34N8878CJones Brian K · Scituate, MABuilt 1953 · S/N 22-1488N8878DHamilton Clyde Leon · Forest, VABuilt 1958 · S/N 22-6052N8878NCampbell Carl F · Amherst, NHBuilt 1969 · S/N 28-25741N8878WBallard Tim · Roseburg, ORS/N 28-10436N8879CMadden John J Jr Co-Trustee · Frostproof, FLBuilt 1953 · S/N 22-1489N8879EFlickinger Charles P · Hermitage, PAS/N 28-7625163N8879JDaddona John M · Oakville, CTBuilt 1965 · S/N 28-2852
Back to AD 81-18-04 R2