OpenAirDocs.org
AD 94-20-04 R2

Registered aircraft · 4,469

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:94-20-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:94-20-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.

N76940Gsh Of Alabama LLC · Huntsville, ALS/N D-8861N7694NBradley Dennis M · Newburgh, MEBuilt 1968 · S/N D-8869N7695NChalk 2 Inc · Apple Valley, CABuilt 1968 · S/N D-8870N769TPatterson David Roy · Lockney, TXBuilt 1972 · S/N D-9395N76BBEdl Sf Enterprise LLC · Coral Springs, FLBuilt 1952 · S/N D-3110N76JMayer Kevin D · Lima, OHBuilt 1958 · S/N D-5616N76KULaurent Michael · Queen Creek, AZS/N D-7319N76NSSmith Kurt W · Henderson, NVBuilt 1957 · S/N D-5065N770THoyer Kyle E · Manassas, VABuilt 1972 · S/N D-9396N7713RWaggoner Mark B · Fort Worth, TXBuilt 1968 · S/N D-8871N7714RPowell Kenneth Wayne · Ann Arbor, MIBuilt 1969 · S/N D-8956N771RBBogin Robert M · Los Angeles, CABuilt 1964 · S/N D-7737N771TFudge Justin · Karnes City, TXBuilt 1972 · S/N D-9415N772DMihealsick John C · Spring, TXBuilt 1951 · S/N D-3042N7737RPassmore Jay A · Birchwood, TNBuilt 1968 · S/N D-8876N7740RRegistered aircraftBuilt 1968 · S/N D-8877N7747BBrawner Robert M · San Leon, TXBuilt 1959 · S/N D-6181N774DFEclipse Aviation LLC · Las Vegas, NVBuilt 1964 · S/N D-7395N774SDr Leasing Ltd · Wilmington, DEBuilt 1966 · S/N D-8088N775TSorensen Craig A · Fallon, NVBuilt 1974 · S/N D-9664N7761RMarrow Henry Gregory · Southern Pines, NCBuilt 1968 · S/N D-8879N7765RDumbo Aviation LLC · Omaha, NEBuilt 1968 · S/N D-8882N7768RIvey Martin J · Dennis, TXBuilt 1968 · S/N D-8897N7769RPelican Air Inc · Kersey, PABuilt 1968 · S/N D-8906N776DBHagglund Carl D · Pendleton, ORBuilt 1952 · S/N D-3046N7772RBpk Ventures LLC · Jupiter, FLBuilt 1968 · S/N D-8896N7777RBryson Thomas M · Jackson, MSBuilt 1962 · S/N D-7050N777BAGado Theodore A · Cortlandt Manor, NYBuilt 1972 · S/N D-9408N777BCBas Part Sales LLC · Greeley, COBuilt 1966 · S/N D-8230N777CEMiller Dana · Tracy, CABuilt 1977 · S/N D-10019N777FHShort Final LLC · Mooresville, NCBuilt 1964 · S/N D-7530N777GPAkc Aviation LLC · Lake In The Hills, ILBuilt 1962 · S/N D-7009N777JMFulton David S · Austin, TXBuilt 1966 · S/N D-8085N777KWBenner Dick L · Clancy, MTBuilt 1968 · S/N D-8892N777PDIsr Aviation LLC · Wilmington, DEBuilt 1981 · S/N D-10380N777SMJohnson Paul T · Red Oak, TXBuilt 1955 · S/N D-4400N777TLStemmer Steven N · Huntersville, NCBuilt 1966 · S/N D-8302N777UPerez Michael Joel D · San Diego, CABuilt 1970 · S/N D-9096N777WCHome Run Rv LLC · Helena, MTBuilt 1952 · S/N D-3148N777WDMob Aviation USA LLC · Auburndale, FLBuilt 1960 · S/N D-6491N777XBWinds Aloft LLC · Brookshire, TXBuilt 1969 · S/N D-8948N777YAerotrack Inc · Hemet, CABuilt 1966 · S/N D-8296N777ZDiefenthal Douglas C · Roselle, ILBuilt 1964 · S/N D-7482N7786RWinfree Charles E · Edgewood, TXBuilt 1968 · S/N D-8884N7797RTurner Michael C · Suffolk, VABuilt 1968 · S/N D-8890N779DGlendaloch Partners Lp · El Reno, OKBuilt 1951 · S/N D-3048N779RBRbi Trading LLC · Morton Grove, ILBuilt 1966 · S/N D-8244N77BJHint Peter T · Centerport, NYBuilt 1974 · S/N D-9698N77CYN77cy LLC · Lambertville, MIBuilt 1974 · S/N D-9678N77FHCumbey Joseph S · Scroggins, TXBuilt 1977 · S/N D-10035
Back to AD 94-20-04 R2