AD 73-07-07

Registered aircraft · 1,108

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:73-07-07')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-07-07')
  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.

N121BKSeabee Training Corp · Birmingham, ALBuilt 1977 · S/N 310R0893N122SBCessna Twin Flyers LLC · Calhoun, TNS/N 310R0873N123DEGearhart John D · Arlington, WAS/N 35926N124DPBaja Air LLC · Wilmington, DEBuilt 1979 · S/N 310R1670N125DMCallegari Gino A · Susanville, CABuilt 1966 · S/N 310K0176N126TMFlynfish Air LLC · Rome, GAS/N 310R1231N1274GSol Aerial Surveys LLC · Las Vegas, NVBuilt 1974 · S/N 310R0001N127MBBerger Max · Daytona Beach, FLBuilt 1976 · S/N 310R0654N1280GSky Aviation And Consulting · Panorama City, CABuilt 1976 · S/N 310R0692N1296GAir Dogs LLC · Watford City, NDBuilt 1976 · S/N 310R0698N1297GPilot Mountain Aviation LLC · Marietta, OHBuilt 1974 · S/N 310R0003N129ASPyxis Air LLC · Wilmington, DEBuilt 1976 · S/N 310R0663N129DPSplendid Air Leasing LLC · Corpus Christi, TXS/N 310L-0006N12TTThoms Robert D · Clyde, MIS/N 310H0066N12VLCrow Edward N Jr · Silverdale, WAS/N 310P0171N1313RAztexas LLC · Valley Farms, AZS/N 310J0178N131PBTom Tatum Pa · Danville, ARBuilt 1975 · S/N 310R0514N1321GInnovative Poultry Products LLC · Olar, SCBuilt 1976 · S/N 310R0701N1338GWings Air Charter LLC · Wisconsin Rapids, WIBuilt 1974 · S/N 310R0022N1339GLyon Aviation Inc · Pittsfield, MABuilt 1974 · S/N 310R0023N133CWDeniro Corp · Hampton, NHBuilt 1978 · S/N 310R1260N1342GSpector Steven D · Glenview, ILBuilt 1974 · S/N 310R0026N1346GClear Blue Aviation LLC · Melbourne, FLBuilt 1974 · S/N 310R0029N1349GWings Of Grace Ministries Inc · Melbourne, FLBuilt 1976 · S/N 310R0706N1351G310 LLC · Conover, NCBuilt 1976 · S/N 310R0708N1359GEaglehead Aviation LLC · Tifton, GABuilt 1976 · S/N 310R0714N1361QLannigan Anthony Robert · Tucson, AZBuilt 1959 · S/N 39017N137Bigfoot Aviation LLC · Saint Michael, MNBuilt 1960 · S/N 310-0028N1371GFall Gregory F · Hanson, MABuilt 1976 · S/N 310R0725N137DMiller Aviation LLC DBA · Huntington, INBuilt 1981 · S/N 310R2136N13BPN13bp LLC · Walla Walla, WAS/N 320D0123N13PKOaks Aviation LLC · Clear Lake, MNBuilt 1981 · S/N 310R2127N142CTMiddleton Charles H · Hamilton, INFirst renewal noticeBuilt 1976 · S/N 310R0629N143MGPatriot Air Inc · Maryland Heights, MOS/N 310K0134N143SWBb&D Airways LLC · N Redngtn Bch, FLS/N 310R1856N1491Petecraft Aviation Services Inc · Plains, GABuilt 1960 · S/N 39202N14BRGobin Albert W · Crawfordsville, INS/N 310K0104N14MCBlue Skies Blue Water LLC · Henderson, NVBuilt 1964 · S/N 320C0008N150BGMbw Aviation LLC · Bay City, MIS/N 310R-0635N1565TForbes Consolidated Inc · New Smyrna Beach, FLBuilt 1974 · S/N 310R0063N157CCWhite David W · South Fulton, TNS/N 310I0157N1581GKovach Kenneth R · Jefferson, OHBuilt 1979 · S/N 310R1593N15DSAll Attitude Aviation Inc · Edgewater, FLBuilt 1965 · S/N 320D0079N15TVDfl Management Corp · New Castle, DES/N 310R0945N15WRAcmc Operations LLC · Cedar Park, TXBuilt 1975 · S/N 310R0553N165MHFortune Kyle D · Hampstead, NCBuilt 1966 · S/N 310K0173N166AMColvin Clu D DBA · Big Cabin, OKBuilt 1963 · S/N 310H0127N168EDTsg Aviation LLC · Wyandotte, MIBuilt 1975 · S/N 310R0134N169DKStanton James · North Barrington, ILBuilt 1978 · S/N 310R1412N1710HQuon Nicholas · Fayetteville, GABuilt 1959 · S/N 35810
Back to AD 73-07-07