AD 77-01-08

Registered aircraft · 107

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-08')
    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-08')
  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.

N112SJSuchomel Chase E · North Saint Paul, MNS/N 38N112WNEvans William M · Nipomo, CABuilt 1974 · S/N 169N1137JDaugusta Richard J · Lexington, MAS/N 137N1140JGardner John D · Tallahassee, FLBuilt 1974 · S/N 140N1143JDurrah Anthony E Sr · Charlotte, NCBuilt 1974 · S/N 143N1144JLee Carl B · Bullard, TXBuilt 1974 · S/N 186N1145JPrestridge Austin · Newark, OHBuilt 1974 · S/N 145N1147JSandel Henry Adrian III · Natchez, MSBuilt 1974 · S/N 132N114SLSimply Living LLC · Fort Myers, FLS/N 122N1151JRescue Evangelical Church · Fitchburg, MABuilt 1974 · S/N 151N1156JTeam Omega Multimedia Ohio LLC · Blacklick, OHBuilt 1974 · S/N 156N1160JSchreiber William E II · Edgar, WIBuilt 1973 · S/N 125N1161JMnd Services LLC · Joliet, ILBuilt 1974 · S/N 161N1163JBottom Line Aviation LLC · Scranton, NDS/N 163N1170JHoward Thomas D · Bunnlevel, NCBuilt 1974 · S/N 170N1173JCohelios LLC · Oviedo, FLBuilt 1974 · S/N 135N1174JOlson Michael J · Viroqua, WIBuilt 1974 · S/N 174N1180JVegas Alex · Leesburg, VAS/N 149N1181JWinston James Eldon Jr · Granbury, TXBuilt 1974 · S/N 181N1182JAndrew Kenneth S · Dawson, GABuilt 1974 · S/N 155N1185JBirk Ronald G · Wellington, NVBuilt 1974 · S/N 178N1189JCollom David M · Lockport, ILBuilt 1974 · S/N 189N1190JSeignious Russell V · Pass Christian, MSBuilt 1974 · S/N 190N1191JMag-Nif Inc · Mentor, OHBuilt 1974 · S/N 234N1193JFloyd Michael E · Tulsa, OKS/N 185N1194JSmith Jerry L · Newport News, VAS/N 194N1195JRickard Trucking Inc · Eddyville, KYBuilt 1974 · S/N 195N1202JAldrich Curtiss · Aguila, AZBuilt 1974 · S/N 202N1204JLucas Rici · Columbus, GABuilt 1974 · S/N 204N1210JBerry Stephen B · Dunn, NCBuilt 1974 · S/N 210N1211JChristensen Allen · Clayton, CABuilt 1974 · S/N 211N1212JDobmeier Mark M · Grand Forks, NDS/N 212N1215JRinggold Rolf E · Circle Pines, MNBuilt 1974 · S/N 215N1218JWeeks Wesley J · Iowa Park, TXS/N 218N1226JMores Glenn S · Boxford, MABuilt 1974 · S/N 226N1231JMattson Paul · Chula Vista, CAS/N 231N1240JRinger Kevin L · Grants Pass, ORS/N 240N1242JLouisiana Aviation LLC · Marksville, LABuilt 1974 · S/N 242N1247JSalazar Raul · Bradenton, FLBuilt 1975 · S/N 247N1250JFranchise Aviation LLC · Sparta, NJS/N 250N1254JWidener William J · Chillicothe, ILBuilt 1975 · S/N 254N128ADWahl Flying LLC · Germantown, WIBuilt 1974 · S/N 219N12FPElliott James R · Denton, TXBuilt 1974 · S/N 238N1429JWooley Michael W · Navarre, FLBuilt 1976 · S/N 429N1476JDodgen Charles W · Thomaston, GABuilt 1976 · S/N 476N197RCCaride Jose · Spring Hill, FLBuilt 1974 · S/N 197N202RRNorton Edward A · Las Vegas, NVS/N 350N24BBSj Aviation LLC · Oxford, MIBuilt 1974 · S/N 157N27007Otstot Todd M · Boise, IDBuilt 1976 · S/N 483N324XFontenot Ira Dean · Collierville, TNBuilt 1975 · S/N 300
Back to AD 77-01-08