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.

N236STOutdoor Metal Products LLC · Leighton, ALBuilt 1968 · S/N 401A0020N237DWTheis Industrial Leasing Inc · Spivey, KSS/N 35506N238FALetourmeau University · Longview, TXBuilt 1972 · S/N 421B0238N239SERiley Charles Sweeney · Highlands Ranch, COBuilt 1972 · S/N 421B0315N23DTAlastrom Aviation LLC · Wilmington, DEBuilt 1975 · S/N 421B0852N23JDraco Flight School Inc · Chino, CAS/N 310I0108N23PFBagge Tom · Monticello, IABuilt 1968 · S/N 310P0044N240GBSchumaker Joseph W Jr · Petersburg, MIBuilt 1966 · S/N 310K0188N240RATop Aircraft Leasing LLC · Wilmington, DES/N 310Q0108N240RTAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1975 · S/N 421B0863N241AJAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1958 · S/N 35789N241AREllison Aviation LLC · Conroe, TXBuilt 1967 · S/N 320F-0012N241TSGrey Matter Inc · Valley Springs, CAS/N 421B0110N242HB2hb Airways LLC · Saint Louis, MOBuilt 1970 · S/N 421B0049N245BMBen-Hur Air Chariots LLC · Fort Myers, FLBuilt 1971 · S/N 310Q0411N246BGuynn Dane L · Peachtree City, GAS/N 310K0030N247CTConsolidated Technologies · Woodbury, MNBuilt 1961 · S/N 320-0058N247EFNobles Vernon H Jr · Calabasas, CABuilt 1968 · S/N 310P0023N24KMNorthern Jet Inc · Iron Mountain, MIS/N 310Q0631N24PMHaven Harmony LLC · Sheridan, WYBuilt 1973 · S/N 310Q0705N251WWEbbert Thomas E DBA · Gary, INRegistration revokedBuilt 1967 · S/N 411-0251N255AOld Aircraft Inc · Lake City, FLBuilt 1956 · S/N 35285N255MBPhoenix Aircraft Management LLC · Marathon, FLBuilt 1968 · S/N 310N-0110N257JDAntonini Vittorio · New York, NYBuilt 1970 · S/N 310Q-0071N25EWBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 310K0063N25FERound Trip Lc · Elkhart, KSS/N 421-0055N25LPBer Aviation Inc · Saratoga, CABuilt 1973 · S/N 310Q0748N2602CRrb Aviation LLC · Jasper, TXBuilt 1954 · S/N 35002N2610CNelson Scott J · Saline, MIBuilt 1954 · S/N 35010N261REPeterson Randy J · Sonoma, CAS/N 35284N2638CPickett Joseph C · El Paso, TXBuilt 1955 · S/N 35038N2642CMuniz Elmer · Port Saint Lucie, FLS/N 35042N2655CSmith Lionel J · Ironton, MOBuilt 1955 · S/N 35055N2671CHouchen Chris F · Palmer, AKBuilt 1955 · S/N 35071N2672CClipper Sky LLC · Las Vegas, NVS/N 35072N2674CTri County Sprayers Inc · Hamlin, TXBuilt 1955 · S/N 35074N2689CColvin Clu DBA · Big Cabin, OKS/N 35089N268YMilton Quincy N · Bellevue, WABuilt 1959 · S/N 35846N2695CNovak Peter A · Barrington, ILBuilt 1955 · S/N 35095N269FAir2615 LLC · Wilmington, DEBuilt 1968 · S/N 421-0177N27JPWillis Roger · Bellview, FLS/N 39129N27ZZJohnson John C · Coeur D Alene, IDBuilt 1964 · S/N 310I0100N2836DSale Reported · Yucaipa, CASale reportedBuilt 1966 · S/N 411-0190N285NTotem Air Inc · Seattle, WABuilt 1968 · S/N 421-0169N28835Waddingham William B · Rancho Cucamonga, CABuilt 1969 · S/N 421A-0050N289VVBooth Emmett W · Waitsburg, WAS/N 320E-0110N2901RBerry & Sons Trucking LLC · Eufaula, OKBuilt 1962 · S/N 310G0101N2905RKlassen Thomas · Corpus Christi, TXS/N 310G0105N2918RTown Thomas L · Chino Valley, AZBuilt 1968 · S/N 310G0118N2920RCarboneau Luke · Las Cruces, NMBuilt 1962 · S/N 310G0120
Back to AD 72-14-08 R1