OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,369

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.

N734UUPenn Aero LLC · Lewisburg, PABuilt 1977 · S/N 17269132N734UVCavu Flying Club · Wauwatosa, WIBuilt 1977 · S/N 17269133N734UWFisher Stephen C Trustee · Lamar, ARS/N 17269134N734UXJantz Carl R · Columbia, MOBuilt 1977 · S/N 17269135N734UYAg & Csv Inc · Pine Bush, NYBuilt 1977 · S/N 17269136N734UZDream Unthreatened LLC · San Luis Obispo, CABuilt 1977 · S/N 17269137N734VCNashville Skyscrapers LLC · Old Hickory, TNBuilt 1977 · S/N 17269140N734VEFlyby Aviation LLC · Logan, UTBuilt 1977 · S/N 17269142N734VNKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1977 · S/N 17269150N734VPBooth Danielle M · Somis, CABuilt 1977 · S/N 17269151N734VQJprg Aviation Inc · Orlando, FLBuilt 1977 · S/N 17269152N734VSVitatoe Industries Inc · Chillicothe, OHBuilt 1980 · S/N P21000614N734VTDestination Aviation LLC · Destin, FLBuilt 1977 · S/N 17269155N734VVSummit Flight Services LLC · Paden, OKBuilt 1977 · S/N 17269157N734VXRed Door Aviation LLC · Dover, DEBuilt 1977 · S/N 17269159N734VZTri Air Inc · Aulander, NCBuilt 1977 · S/N 17269161N734WBWedoaero LLC · Vale, NCS/N 17269163N734WFLewis Patrick K · El Dorado, ARS/N 17269167N734WGStone Aviation LLC · Traverse City, MIBuilt 1980 · S/N P21000615N734WHObermeyer Keith · Excelsior, MNBuilt 1980 · S/N P21000616N734WKWagner James M · Hockessin, DEBuilt 1977 · S/N 17269171N734WLFlight Answers LLC · Miami Lakes, FLS/N 17269172N734WNBoerne Flight Options LLC · Boerne, TXBuilt 1977 · S/N 17269174N734WPLaps LLC · Elkhorn, WIBuilt 1977 · S/N 17269175N734WRSealy Michael Robert · Summerville, SCBuilt 1977 · S/N 17269177N734WSWingsleasing LLC · Wichita, KSBuilt 1977 · S/N 17269178N734WZTingman Christopher · Seattle, WABuilt 1977 · S/N 17269185N734XCCurrier William R · Ormond Beach, FLBuilt 1977 · S/N 17269188N734XDByrne David · Three Rivers, MIBuilt 1977 · S/N 17269189N734XHFlyright Aviation Inc · North Las Vegas, NVS/N 17269193N734XKEllig Todd L · Horace, NDBuilt 1977 · S/N 17269195N734XLWalsh Patrick Sean · Osterville, MABuilt 1977 · S/N 17269196N734XMTri Star Cac LLC · Plano, TXBuilt 1977 · S/N 17269197N734XPDutcher John A · Cedar Falls, IAS/N 17269199N734XQSumter County Sheriffs Office · Sumter, SCBuilt 1977 · S/N 17269200N734XRWingsleasing LLC · Wichita, KSBuilt 1977 · S/N 17269201N734XSCrabtree Clifford I · Ukiah, CABuilt 1977 · S/N 17269202N734XTFlying Colors Airparts Inc · Leesburg, FLBuilt 1977 · S/N 17269203N734XXHuerta Holdings Inc · Santa Ana, CABuilt 1977 · S/N 17269207N734XYBend Aircraft Mechanics LLC · Bend, ORBuilt 1977 · S/N 17269208N734YALuxair LLC · College Station, TXBuilt 1977 · S/N 17269210N734YBHrbk LLC · Grandview, INBuilt 1977 · S/N 17269211N734YCShaw Terry R · Olympia, WAS/N 17269212N734YDWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 17269213N734YLTactical Integrated Training Solutions LLC · San Antonio, TXBuilt 1977 · S/N 17269220N734YMStockbridge Valley Flying Club Inc · Syracuse, NYBuilt 1977 · S/N 17269221N734YVHarvey David C · Wellsboro, PABuilt 1977 · S/N 17269229N734YXKvalita John C Jr · Port Charlotte, FLBuilt 1977 · S/N 17269231N734ZAHanson Brian · Sauk City, WIBuilt 1977 · S/N 17269234N734ZBCurten Clay A · Evansville, ILS/N 17269235
Back to AD 80-25-07 R1