OpenAirDocs.org
AD 77-03-01

Registered aircraft · 119

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-03-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:77-03-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.

N108SAFlying A Flight Service LLC · Safford, AZBuilt 1977 · S/N 11416N112EESpur Aviation Services Lc · Twin Falls, IDBuilt 1976 · S/N 11330N121JWGlobal Jet LLC · Missoula, MTBuilt 1975 · S/N 11299N127HJPonderosa Aviation LLC · Safford, AZBuilt 1978 · S/N 11467N13RABarney Adam Joseph · Altamonte Springs, FLBuilt 1975 · S/N 11235N1420VCommander Trust LLC · Fort Lauderdale, FLBuilt 1979 · S/N 11524N15CDCommander N15cd LLC · Miami, FLS/N 11177N15SFKolob Canyons Air Services Inc · Wilmington, DEBuilt 1979 · S/N 11528N162ALNeptune Aviation Services Inc · Missoula, MTBuilt 1975 · S/N 11231N167RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1978 · S/N 11437N186EOmeara John S Trustee · Newport Beach, CABuilt 1979 · S/N 11566N197GBPonderosa Aviation LLC · Safford, AZBuilt 1975 · S/N 11282N20MAOberon Management LLC · Fort Smith, ARBuilt 1978 · S/N 11514N2141BAmhurst Development Inc · Lewes, DEBuilt 1978 · S/N 11484N222MEClearwater Airco LLC · Anchorage, AKS/N 11338N225MMJ & M Aircraft Holding LLC · Bellaire, TXBuilt 1978 · S/N 11462N231AVTeton Leasing LLC · Pocatello, IDBuilt 1977 · S/N 11353N245CFEagle Creek Aviation Services Inc · Indianapolis, INBuilt 1976 · S/N 11313N24GTPia Avcenter LLC · Peoria, ILBuilt 1975 · S/N 11254N251ESLumphanan LLC · Adams, NEBuilt 1975 · S/N 11251N25CEKoy Dean R · Houston, TXBuilt 1977 · S/N 11400N260WEFlying A Flight Service LLC · Safford, AZBuilt 1979 · S/N 11536N267RDReisen LLC · Stevensville, MTBuilt 1978 · S/N 11456N30854Cornerstone Financial Enterprises LLC · Mesquite, NVS/N 11229N31BVCourtney Aviation LLC · Columbia, CAS/N 11315N32ALAero Air LLC · Hillsboro, ORBuilt 1976 · S/N 11336N32GASpur Aviation Services Lc · Twin Falls, IDBuilt 1974 · S/N 11215N32WSPonderosa Aviation LLC · Safford, AZBuilt 1976 · S/N 11339N362SHFlight-Plan One LLC · Bay City, MIBuilt 1976 · S/N 11316N364WAAerokinetical Aviators LLC · West Chester, OHBuilt 1977 · S/N 11439N36JFMmdex LLC · Carlisle, PABuilt 1978 · S/N 11478N383HCAc690 LLC · Alpine, WYBuilt 1975 · S/N 11310N3869FElkhorn Aviation Inc · Baker City, ORBuilt 1973 · S/N 11141N38LMKoy Dean · Houston, TXBuilt 1977 · S/N 11424N38WAAirborne Support Inc · Houma, LABuilt 1974 · S/N 11169N400DSSpur Aviation Services Lc · Twin Falls, IDBuilt 1978 · S/N 11512N40SMCo Fire Aviation Leasing Inc · Fort Morgan, COBuilt 1979 · S/N 11559N420LWCrazy Horse LLC · Princeton, WVS/N 11455N425DTSun Fast Inc · Mansfield, TXBuilt 1978 · S/N 11519N449LCTj Air Holdings Inc Trustee · Wilmington, DES/N 11187N44NCPonderosa Aviation LLC · Safford, AZBuilt 1977 · S/N 11387N45AZPonderosa Aviation LLC · Safford, AZBuilt 1977 · S/N 11383N4717VCourtney Aviation LLC · Columbia, CAS/N 11220N47EPRum Bum Distributors Inc · Miami, FLBuilt 1978 · S/N 11520N480KSpur Aviation Services Lc · Twin Falls, IDBuilt 1976 · S/N 11543N5016HBest Aircraft Deals LLC · Salt Lake City, UTS/N 11452N50DXYada Yada Yada Inc DBA · Fresno, CABuilt 1974 · S/N 11227N52PYJk Aviation LLC · Carson City, NVS/N 11196N53GEWings & Rotors LLC · Wilmington, DES/N 11404N555VEPia Avcenter LLC · Peoria, ILBuilt 1979 · S/N 11546
Back to AD 77-03-01