AD 94-05-05 R1

Registered aircraft · 26,231

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-05-05-R1')
    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-05-05-R1')
  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.

N1474BSanderson David K · Scotts Valley, CABuilt 1948 · S/N 6101N1475ELittle Jack E · Granbury, TXBuilt 1946 · S/N 7AC-5038N1475HHebbard Gary D · Bethel, OHS/N 15AC-546N1475YAbe Lincoln Flyers Inc · Lincoln, ILBuilt 1962 · S/N 17249175N1476QHarley Dennis E Sr · Cole Camp, MOBuilt 1971 · S/N 15072776N1476YHamilton Gene A · Saegertown, PABuilt 1962 · S/N 17249176N1477FMavity Reagan Chase · Clayton, GABuilt 1966 · S/N 17254972N1478DBailey James W Jr · Burleson, TXBuilt 1951 · S/N 20061N1478FElliott Gabrial Adam · Hollywood, ALBuilt 1966 · S/N 17254973N1478YCunningham Richard E · Lafayette, CABuilt 1962 · S/N 17249178N147HLeroy Philippe G · Willcox, AZBuilt 1964 · S/N DH41N147PZZattoni Peter D · Mountain Iron, MNBuilt 1947 · S/N 11-1084N1480BN1480b LLC · Wentzville, MOBuilt 1948 · S/N 6107N1481YPoole Timothy W · Lyons, GABuilt 1962 · S/N 17249181N1482DSiebe Carl F · Anchorage, AKBuilt 1951 · S/N 20065N1482YSamuelian Jenna A · Tehachapi, CABuilt 1962 · S/N 17249182N1483DFlying Plane LLC · Bartow, FLBuilt 1951 · S/N 20086N1483QAttax LLC · Missoula, MTBuilt 1971 · S/N 15072783N1483VRankin Kevin · Maryville, MOS/N 17250241N1484QIntegrated Structural Services Inc · Ringgold, GABuilt 1971 · S/N 15072784N1484YHarrison Dennis N · New London, MOS/N 17249184N1485QMartin Aviation LLC · Bargersville, INS/N 15072785N1486YPost Greg · Fort Scott, KSBuilt 1962 · S/N 17249186N14881Rhinehart Daniel · Placentia, CABuilt 1936 · S/N 105N14882Registration Pending · Oklahoma City, OKRegistration pendingBuilt 1972 · S/N 506N14883Walker Bobbie R · Denver, COBuilt 1975 · S/N 507N14884Buck Carl W · Longmont, COBuilt 1978 · S/N 508N1488QTorney Sean M · Angier, NCBuilt 1971 · S/N 15072788N1489DAce Hole Flying Club LLC · Spokane, WABuilt 1951 · S/N 20091N1489FHoover Andrew V · Jenison, MIBuilt 1966 · S/N 17254984N148CKOtto David · Saint Thomas, MOBuilt 2010 · S/N 75-7497N148ELFrazier James M III · Saint Marys, KSBuilt 1975 · S/N 15077412N1490BEspinoza Cheryl · Littleton, COBuilt 1948 · S/N 6117N1490DCole Daniel G · Pittsburgh, PAS/N 20092N1491HMacveigh Craig A · New Carlisle, OHS/N 15AC-561N1491YBullard Thomas Eugene Trustee · Midlothian, TXBuilt 1962 · S/N 17249191N1492BSwift Johathan T · Castle Pines, COS/N 6119N1492DLevin Amanda L Trustee · Prairie Du Sac, WIBuilt 1951 · S/N 20094N1492QDavison James D · Richmond, MAS/N 15072792N1493DJobe Waylen Mark · Eugene, MOBuilt 1951 · S/N 20095N1493FAdventist World · Wilson, NCBuilt 1966 · S/N 17254988N1494DFuller Scott M · Edinburg, TXBuilt 1951 · S/N 20096N1494FThompson Kevin L · Jefferson, TXBuilt 1966 · S/N 17254989N1494QSauter Allen · Bismarck, NDBuilt 1971 · S/N 15072794N1496FSmith James F · Red Springs, NCBuilt 1966 · S/N 17254991N1496QDonat Brandon L · Glendale, AZBuilt 1971 · S/N 15072796N1496YHoward Paul D · Gordon, TXS/N 17249196N1497FBlunk Rodney · Bettendorf, IABuilt 1966 · S/N 17254992N1497YHall Robert D · Prince-Frederick, MDBuilt 1962 · S/N 17249197N1499BWeaver Jack · Salt Lake City, UTBuilt 1948 · S/N 6126
Back to AD 94-05-05 R1