OpenAirDocs.org
AD 72-14-08 R1

Registered aircraft · 1,578

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:72-14-08-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:72-14-08-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.

N4076QSandoval Juan · Valley Stream, NYBuilt 1968 · S/N 401-0176N407RKMoore John C · San Miguel, CABuilt 1968 · S/N 401-0181N40JCDbs Aviation LLC · Sulphur Springs, TXBuilt 1973 · S/N 421B0384N41019Sjs Flights Lp · Columbus, GABuilt 1973 · S/N 421B0401N41041Mathews Christopher D · Blue Earth, MNBuilt 1973 · S/N 421B0412N41055J&B Aircraft LLC · Anaheim, CABuilt 1974 · S/N 421B0576N41085421 Bravo LLC · Marine City, MIS/N 421B0440N4108QStuckle Gary W · Davenport, WABuilt 1967 · S/N 310N-0008N410ECSoutheast Enterprises LLC · Dothan, ALBuilt 1973 · S/N 421B0422N41106Delorenz Robert J · Boca Raton, FLBuilt 1974 · S/N 421B0589N41114Iacobacci Timothy R · Fairborn, OHBuilt 1973 · S/N 421B0458N41124Wenta Nip & Sanitizing LLC · Monte Vista, COBuilt 1973 · S/N 421B0465N411DCWillert Fred J · San Diego, CABuilt 1965 · S/N 411-0135N411GCadwell Bradley L · Orlando, FLBuilt 1964 · S/N 310I0125N411TBLewis Nathan · North Plains, ORS/N 421B0481N411ZJkdj LLC · Tyler, TXBuilt 1973 · S/N 421B0482N4120QJade Air LLC · Middle River, MDS/N 310N-0020N4122QV V S Implements LLC · Wilmington, DEBuilt 1967 · S/N 310N-0022N4123TRace Dean · Chicken, AKBuilt 1966 · S/N 320D0023N4127QHurd Aviation LLC · Lexington, KYBuilt 1967 · S/N 310N-0027N412DGJannelli Gilbert DBA · Clearwater, FLS/N 35690N412SJRegistration Pending · La Place, LARegistration pendingS/N 310-0037N4130TSteven J Leavitt · Avondale, AZS/N 320D0030N4132QKarlen John R IV · Edwards, CABuilt 1967 · S/N 310N-0032N4133QGaston Prentice W Jr · Carmel, INBuilt 1967 · S/N 310N-0033N4135TNehls Chevrolet Olds Cadillac · Marshall, TXBuilt 1965 · S/N 320D0035N4138TLindquist Holdings LLC · Noblesville, INBuilt 1965 · S/N 320D0038N413DGWindsock Capital LLC · Bertram, TXBuilt 1959 · S/N 35814N4140QJohnson Kyle A · Cheshire, CTBuilt 1968 · S/N 310N-0040N4144Q470 Corp · White Lake, MIBuilt 1968 · S/N 310N-0044N4148QRomeo Carmen J · Beaver, PABuilt 1968 · S/N 310N-0048N4149QMustain Michael J · Monticello, GABuilt 1968 · S/N 310N-0049N414SGCloud Niner Aviation LLC · Zephyrhills, FLS/N 310P0067N414XMaag Wilford Darcy · Caldwell, IDBuilt 1962 · S/N 310G0091N4154TNunya Business LLC · Middletown, DES/N 320D0054N4156TRichard Brady K · Farmers Branch, TXBuilt 1965 · S/N 320D0056N4159TGholami Amir H · Santa Rosa, CABuilt 1965 · S/N 320D0059N415RABoas Mark S · Hollywood, MDBuilt 1975 · S/N 421B0874N4163TKasper Heath · Albany, ORS/N 320D0063N4165QGhiselli William A III · Woodruff, WIBuilt 1968 · S/N 310N-0065N4166QMays Kevin E · West Liberty, KYS/N 310N-0066N4167GW J Medical Consulting · Caguas, PRBuilt 1976 · S/N 402B1214N4167QHawkeye Helicopter LLC · Lyndon, KSBuilt 1968 · S/N 310N-0067N4169GNewell Henry O Jr · Roxboro, NCS/N 402B1215N4169QMarasovich Christopher · Youngstown, OHBuilt 1968 · S/N 310N-0069N4175QKabat Jules M · Las Vegas, NVBuilt 1968 · S/N 310N-0075N4177QAdamson Paul · Sparks, NVBuilt 1968 · S/N 310N-0077N417EC417ec LLC · Sheridan, WYBuilt 1972 · S/N 310Q0539N4181QMontgomery Steven D · Cleveland, OKBuilt 1968 · S/N 310N-0081N4181TKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1966 · S/N 320D0081
Back to AD 72-14-08 R1