OpenAirDocs.org
AD 76-04-01

Registered aircraft · 554

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:76-04-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-04-01')
  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.

N100BMarshall Xavier T · Carson, CAS/N 57114N101PQValiair Limited Company Trustee · Casper, WYBuilt 1962 · S/N 21057932N1024Calgonaire LLC · Seminole, TXS/N 57425N109HBadke Paul J · Ray, MIBuilt 1962 · S/N 21057921N10RVKoehn Shane Michael · Scooba, MSBuilt 1964 · S/N 21058418N123KTHolliday Paul B · Kiln, MSBuilt 1963 · S/N 21058218N12RFMckay Jonathan S · Chesapeake, VAS/N 21057612N12WDHamburg Jeffrey · Corsica, SDS/N 57480N13BJSevcik Clint · Medford, MNS/N 21058486N141DMTurbo Inc · Flint, MIBuilt 1977 · S/N 21061806N155KTN155kt LLC · Dover, DEBuilt 1963 · S/N 21058196N157LMBaughman David · Jeffersonville, INBuilt 1961 · S/N 21057764N165WFHardin John M · Terrell, TXBuilt 1962 · S/N 210-57875N1724THanna David B · Tonasket, WABuilt 1964 · S/N 21058360N17ABBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 21057674N17TCKenyon Walter C · Eureka Springs, ARBuilt 1964 · S/N 21058499N18PWPhenix LLC · Dayton, WABuilt 1963 · S/N 21058192N198PBolski Dariusz · Rancho Cordova, CABuilt 1960 · S/N 57319N198RPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 210-61063N200NMOrr Leroy A · Tonasket, WABuilt 1960 · S/N 57271N205NBAirmotive Service LLC · Brigham City, UTBuilt 1962 · S/N 205-0151N210AKMaxinkuckee Aviation LLC · Columbus, INS/N 21061627N210AWJohnson Matt R · Fox Island, WABuilt 1964 · S/N 21058492N210EBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 21058365N210EAFollis Allen J · San Tan Valley, AZBuilt 1962 · S/N 21057973N210GNJackson Flying LLC · Siloam Springs, ARBuilt 1961 · S/N 21057803N210GTTeufel Gregory W · Lake Stevens, WABuilt 1961 · S/N 21057590N210JRSouthard Robert W · Elk City, OKBuilt 1959 · S/N 57017N210KCFluid Media Inc · Moscow, IDS/N 21061595N210KEKampel Thomas E · Wellsville, PAS/N 21058505N210NSNovember Sierra Aviation LLC · Oneill, NEBuilt 1960 · S/N 21057595N210PRShaw Ronald V · Edmond, OKS/N 64883N210RRBeasley Emmett C · Bixby, OKBuilt 1960 · S/N 57503N210TFAll About The Doodles Inc · Kirkland, ILS/N 21057793N210WKCorrado Christopher · Newton, NJBuilt 1960 · S/N 57088N210WMBryan-Kennedy LLC · Tulsa, OKBuilt 1963 · S/N 21058287N210XXRegistration Pending · Porter, TXRegistration pendingBuilt 1964 · S/N 21058402N210YYApr Aviation · Fresno, CABuilt 1960 · S/N 57408N221BFXtratech Corp · Davie, FLBuilt 1963 · S/N 21058135N227DKirkland Daniel · Kingman, AZBuilt 1976 · S/N 21061540N22GPDunkelburg David L · Milton Freewater, ORBuilt 1963 · S/N 58202N2300PNess Dana E · Chester, MTS/N 21057746N2306FBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 21058506N2307FEads Kevin · Arley, ALBuilt 1964 · S/N 21058507N240MMFlood Specialists Group Inc · Des Plaines, ILBuilt 1960 · S/N 57168N241DAMonard Larry R · Anadarko, OKBuilt 1960 · S/N 57563N24KWright Douglas J · Greenwood, INBuilt 1960 · S/N 57265N25JCAvg LLC · Chico, CABuilt 1959 · S/N 57008N2747VDavis Brady L · Monument, COS/N 21058458N321CHSmith James Christian · Rockport, TXBuilt 1962 · S/N 21058061
Back to AD 76-04-01