AD 80-25-07 R1

Registered aircraft · 25,370

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:80-25-07-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:80-25-07-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.

N5902QYow Franklin S · Grand Blanc, MIBuilt 1965 · S/N 817N5903QPressley Brent DBA · Morristown, TNBuilt 1965 · S/N 3186N5904QLorincz Dennis K · Wadsworth, OHBuilt 1965 · S/N 833N5905QWainwright Mitchell J · Saint Charles, MOBuilt 1965 · S/N 3161N5907ERiver City Flying Club Inc · Valley Center, KSBuilt 1978 · S/N 17271957N59086Maxwell James B · Lewiston, IDBuilt 1973 · S/N 611-74N5908QT&T Aviation LLC · Clarksville, TNBuilt 1965 · S/N 819N5909EOwens Flight Training LLC · Lafayette, LABuilt 1978 · S/N 17271958N590SProspect Ridge Aviaton Inc · Morganton, NCBuilt 1981 · S/N 172RG0818N5911QFuller Christopher · Ottsville, PABuilt 1965 · S/N 3164N5912QWilson Paul M · Bonifay, FLS/N 821N5915QHaslem Patrick S · Dimondale, MIBuilt 1965 · S/N 3166N5916JUnited States Air Force - Owner · Eglin Afb, FLBuilt 1980 · S/N 17273845N5916QSeidel Daniel F · Los Altos Hills, CABuilt 1965 · S/N 823N5918QNorheim Bjoern T · Phoenix, AZBuilt 1965 · S/N 824N5919QBig Sky Adventures LLC · Nicholasville, KYS/N 3168N591PHKingdom Air Corps · Sutton, AKBuilt 1966 · S/N 670041N5920QKellogg Annabelle S · Cumming, GABuilt 1965 · S/N 825N5921EPeterson Dennis L · Daleville, ALS/N 18268338N5922EAerial Scouting Solutions LLC · Sioux Center, IABuilt 1978 · S/N 17271963N5924QWright Andrew · Sacramento, CABuilt 1965 · S/N 827N5928EGace Flying Club Inc · Ronkonkoma, NYBuilt 1978 · S/N 17271964N5928QSchmidt Tyren A · Albertville, MNBuilt 1965 · S/N 829N592RJWood Roger E · Waxhaw, NCBuilt 1969 · S/N 702N5933QDonaldson Lucas P · Owyhee, NVS/N 3177N5936QEllis Robert L · Columbus, OHBuilt 1965 · S/N 3180N5937QPospicil John A · Huntsville, ALBuilt 1965 · S/N 3181N5938QNeely Eric R · Seagoville, TXBuilt 1965 · S/N 830N5939EWhite Sound International Ltd · New Smyrna Beach, FLBuilt 1983 · S/N 18268339N593STN593st LLC · Bangor, MEBuilt 1985 · S/N 17276454N5942QBravo J Bravo Aviation LLC · Louisville, KYBuilt 1965 · S/N 831N5943EPlane Zane LLC · Stuart, FLBuilt 1978 · S/N 17271969N5943QFreeborn Andrew B · North Las Vegas, NVBuilt 1965 · S/N 3187N5947NGmm Records · Big Pine Key, FLBuilt 1972 · S/N 17260597N5947QMorales Nelson · Hendersonville, NCBuilt 1965 · S/N 3189N5948ETlt Legacy LLC · Fort Worth, TXBuilt 1978 · S/N 17271972N5948QKrull Lynn · Thompson, IAS/N 3190N594AMMaarouf Mike · Taylor Lk Vlg, TXS/N 243-76N5951ELlano Alfonso · Tucson, AZS/N 17271974N5953QRoberts Stephen C · San Marcos, TXBuilt 1965 · S/N 3193N5954QDominique Jon Andrew · Lenoir, NCBuilt 1965 · S/N 3194N5955EClover Park Technical College · Tacoma, WABuilt 1978 · S/N 17271975N5956EWalsh James · Hayden, IDS/N 17271976N5956QHunt Brian A · Alexandria, VAS/N 3195N5958QInnovative Orthopedics Inc · Arcadia, OKBuilt 1965 · S/N 840N595ACBordlemay John J · Lewisberry, PABuilt 1999 · S/N 834-99N595KHarvey Air LLC · Doylestown, PABuilt 1972 · S/N 17260401N595LTN595lt LLC · Edwards, COS/N P21000008N595VNess David A · Minneapolis, MNBuilt 1966 · S/N 670206N5960QPlett Leo V · Liberal, KSBuilt 1965 · S/N 3197
Back to AD 80-25-07 R1