OpenAirDocs.org
AD 77-01-03

Registered aircraft · 961

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

N1004HSmtm Holdings Inc · Wilmington, DEBuilt 1976 · S/N 28-7715301N1008XSmith Dan V · Anchorage, AKBuilt 1975 · S/N 28-7515373N101GNGreat Northern Aircraft Inc · Griffith, INBuilt 1976 · S/N 28-7615214N1024HBellville Timothy L · Toledo, OHS/N 28-7715302N1026XLopp Russell · Yukon, OKBuilt 1975 · S/N 28-7515375N102DEUniversal Aviators Academy Inc · El Monte, CABuilt 1976 · S/N 28-7615418N1033XHorizon Enterprises LLC · Kalispel, MTBuilt 1975 · S/N 28-7515376N103JKWise Charlie S · Norfolk, VABuilt 1974 · S/N 28-7415271N1040XRacette Robert J Jr · Vienna, WVBuilt 1975 · S/N 28-7515377N1047HMagel James · Fox River Grove, ILS/N 28-7715303N104TBMclear Robert C · Rock Hill, SCBuilt 1973 · S/N 28-7415010N1053HKoehn Danny · Montezuma, KSBuilt 1976 · S/N 28-7715304N1064XActive Pilot Inc · Van Nuys, CABuilt 1975 · S/N 28-7515309N1067YMerino Anthony S · Springville, CABuilt 1974 · S/N 287415020N1068HJudd Gary F · Bend, ORBuilt 1976 · S/N 28-7715305N1076XMarston Lester J · Ukiah, CABuilt 1975 · S/N 28-7515383N1080HAll2fly LLC · Atlanta, GAS/N 28-7715306N108AVDavis Robert S · Keystone Heights, FLBuilt 1974 · S/N 28-7415573N1093XRoseville Aviation LLC · Roxboro, NCBuilt 1975 · S/N 28-7515386N1103XHolmgren Joel A · Chisago City, MNBuilt 1975 · S/N 28-7515388N1107HShurtz William W Jr · Medford, ORBuilt 1977 · S/N 28-7715308N1108HAdk Flying Club Inc · Ballston Spa, NYBuilt 1976 · S/N 28-7715309N1108XThompson Trisha L · Clearwater, KSBuilt 1975 · S/N 28-7515389N110JA3mw Farms Inc · Hallock, MNBuilt 1974 · S/N 28-7515135N1121XCrosscheck Ftc LLC · Greeneville, TNBuilt 1975 · S/N 28-7515316N113EJIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7715075N113KRIal Corp · Lewes, DEBuilt 1974 · S/N 28-7415211N1150XVenture North Aviation LLC · Cloquet, MNBuilt 1975 · S/N 28-7515394N1158HOs Flight LLC · Double Springs, ALS/N 28-7715311N1161HEngert Armin L · Kahului, HIBuilt 1976 · S/N 28-7715312N1163XPerry Curtis · Klamath Falls, ORS/N 28-7515396N1181HAdams Dustan David Sr · Houma, LAS/N 28-7715313N1185HJcaviator LLC · Matthews, NCS/N 28-7715314N120PWBrookhaven Aviation LLC · Brookhaven, MSS/N 28-7415078N12ERPropelling The Gospel Missions Inc · Standish, MEBuilt 1976 · S/N 28-7615099N131RJEggleston William A · Wayland, MABuilt 1974 · S/N 28-7415665N13MPPowell & Powell LLC · Northport, ALS/N 28-7515384N1405XRij Edward · Clovis, CABuilt 1975 · S/N 28-7515292N141TAPray Aviation Inc · Augusta, KSBuilt 1976 · S/N 28-7715201N1423XFigueroa Rafael A Jr · Coulterville, CABuilt 1975 · S/N 28-7515317N1424XLewis Keith W · Clearwater, FLBuilt 1975 · S/N 28-7515318N1425XHowell Joshua · El Cajon, CABuilt 1975 · S/N 28-7515319N1426XBair Preston W Jr · Coshocton, OHBuilt 1975 · S/N 28-7515321N1427XAlis Aquilae LLC · Opelika, ALBuilt 1975 · S/N 28-7515402N1433XEchota Flyers Inc · Calhoun, GAS/N 28-7515406N1464XSymmetry Inc · Sarasota, FLBuilt 1975 · S/N 28-7515410N146JWDodge Inc · Wilmington, DEBuilt 1976 · S/N 28-7615348N1474XKjeldsen Frederik C M · Poughkeepsie, NYBuilt 1975 · S/N 28-7515407N1479XDunn Michael J · Nashua, NHBuilt 1975 · S/N 28-7515411N151DJValley City Flying Club Llp · Valley City, NDBuilt 1975 · S/N 28-7515308
Back to AD 77-01-03