OpenAirDocs.org
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.

N201RUMoore James B · Yorktown, VAS/N 24-0360N201RWRodriguez Ricardo A · Norristown, PAS/N 24-0158N201RX201rx LLC · Russellville, ALBuilt 1977 · S/N 24-0311N201RYTop Shelf LLC · West Fargo, NDBuilt 1977 · S/N 24-0257N201RZGoller Daniel M · Grass Lake, MIBuilt 1977 · S/N 24-0327N201SAQuinn Timothy M · South Haven, MIBuilt 1977 · S/N 24-0114N201SBPatterson James L · Grandview, TXBuilt 1983 · S/N 24-1388N201SDHendin Stuart M · Westminster, MDS/N 24-1611N201SECooper William C · Midlothian, TXBuilt 1990 · S/N 24-1706-14N201SGPhoturis LLC · New Carlisle, OHBuilt 1977 · S/N 24-0178N201SJMcmanus Parker C · Sedona, AZS/N 24-0069N201SKBu James · South Pasadena, CABuilt 1977 · S/N 24-0142N201SLCooley Ben · Owensboro, KYBuilt 1977 · S/N 24-0191N201SNBecker Dean · Sarasota, FLBuilt 1977 · S/N 24-0319N201SQThomas John M · Lake Lure, NCBuilt 1977 · S/N 240298N201SRWagner Stephen S · Liberty, MOBuilt 1977 · S/N 24-0281N201STTillman Stephen · Jacksonville, FLBuilt 1977 · S/N 24-0201N201SVBrown Elijah E · Chino Valley, AZBuilt 1977 · S/N 24-0301N201SWMccrea Alice · Albuquerque, NMS/N 24-0188N201SZRacoon Aviation LLC · San Antonio, TXS/N 24-0285N201TAAdams Toby R · Paris, TXBuilt 1977 · S/N 24-0291N201TCInternational Lift Planning Inc · Anaheim, CABuilt 1977 · S/N 24-0173N201TDHasenauer Matthew R · North Platte, NEBuilt 1977 · S/N 24-0307N201TEBest Power Inc Trustee · Wilmington, DEBuilt 1977 · S/N 24-0289N201TFBartley Jamie K · Johnson City, TNS/N 24-0326N201TJPalmetto Moon Light Services LLC · Mount Pleasant, SCBuilt 1977 · S/N 24-0306N201TKUp Aerospace LLC A Series Of · Georgetown, TXBuilt 1976 · S/N 24-0048N201TLPiorkowski Christian E · Pearland, TXBuilt 1977 · S/N 24-0202N201TMTrujillo John Francisco · Newport News, VABuilt 1978 · S/N 24-0388N201TNMiller Edward J · Amherst, NHBuilt 1996 · S/N 24-3378N201TQJackson Zarick · Pembroke Pines, FLBuilt 1977 · S/N 24-0351N201TRAero Nautical Electronics Inc · Starke, FLBuilt 1977 · S/N 24-0279N201TSJacobsen Eric A · Scottsdale, AZBuilt 1977 · S/N 24-0077N201TTMoore James Ryan · Saint Louis, MOBuilt 1977 · S/N 24-0235N201TVHiivala Robert J · Hanover, MNBuilt 1977 · S/N 24-0332N201TYSingleton Kimberley P · Stuart, FLBuilt 1977 · S/N 24-0322N201TZMayerchak Mark · Mooresville, NCBuilt 1977 · S/N 24-0324N201UAAllard Aviation LLC · Nashua, NHBuilt 1977 · S/N 24-0361N201UBProxima Flight LLC · Spring Lake, MIBuilt 1977 · S/N 24-0362N201UEWoodhams Brian · Wayland, NYBuilt 1977 · S/N 24-0366N201UFReck Robert · Cameron, MTBuilt 1977 · S/N 24-0338N201UGRojemann Nathaniel W · Pass Christian, MSBuilt 1977 · S/N 24-0369N201UJ787 P&G 201 LLC · West Chicago, ILBuilt 1977 · S/N 24-0389N201UKLewis Daniel F · Edgewater, FLBuilt 1977 · S/N 24-0394N201UTRegistered aircraftBuilt 1977 · S/N 24-0313N201UWFlyscotty Development LLC · Gary, INBuilt 1977 · S/N 24-0390N201UXMccallister Randy S · Pulaski, VABuilt 1977 · S/N 24-0391N201UYKirkpatrick Devin B · North Palm Beach, FLS/N 24-0392N201UZForrest Dean L · Hales Corners, WIBuilt 1977 · S/N 24-0393N201VBH3 Aero Concepts LLC · Groveland, FLBuilt 1977 · S/N 24-0372
Back to AD 80-25-07 R1