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.

N6731XThree One X-Ray LLC · Lebanon, OHBuilt 1960 · S/N 310-0031N6734TTravel Guys Ltd · Sparks, NVS/N 39034N6735XLocal Flight Adventures LLC · Morgantown, WVBuilt 1960 · S/N 310-0035N6739XIntravaia Anthony J · Saint Louis, MOS/N 310-0039N6742TMorris Thomas B · Imlay City, MIBuilt 1960 · S/N 39042N6747Ps Afu3a LLC · Monument, COBuilt 1958 · S/N 38106N6748TWhalen John J · West Ossipee, NHBuilt 1960 · S/N 39048N6749XSchindele Micheal D · Tolna, NDBuilt 1961 · S/N 310-0049N6750TArsic Ranko · Hallendale, FLBuilt 1960 · S/N 39050N6756TStanley M C DBA · Caldwell, IDBuilt 1960 · S/N 39056N6758TGill James L Jr · Hernando, MSBuilt 1960 · S/N 39058N6760TTregre Gary M · Fort Worth, TXFirst renewal noticeBuilt 1959 · S/N 39060N6766TAero Research & Development Corp · Bronx, NYS/N 39066N6767TAviation Career Enrichment Inc · Atlanta, GABuilt 1960 · S/N 39067N676MFCoastal Resource Associates Inc · Christiansted, VIBuilt 1971 · S/N 402B0106N6772XKallhoff Mark R DBA · Canby, MNBuilt 1961 · S/N 310-0072N6777MPineiro Enrique · Miami, FLBuilt 1961 · S/N 310-0073N6779TDoyle Mary · Hampton, IABuilt 1960 · S/N 39079N6779XSmith Peter I Trustee · Ocala, FLBuilt 1961 · S/N 310-0079N677HCWashburn Wall Systems LLC · Cedar Rapids, IAS/N 421B0387N6780XN6780x LLC · Duluth, MNBuilt 1961 · S/N 310-0080N6784XSjc Vii LLC · Lawrence, KSBuilt 1961 · S/N 310-0084N6787XTennis Gayland L · Bath, MIBuilt 1961 · S/N 310-0087N678DBGolden Eagle Flight LLC · Farmington, UTBuilt 1975 · S/N 421B0876N6791XEve Scott G · Odessa, TXBuilt 1961 · S/N 310-0091N6792T2a Emergency Site Services LLC · Swainsboro, GABuilt 1960 · S/N 39092N6797XJ & W Air LLC · Wilmington, DEBuilt 1961 · S/N 310-0097N67CMSmith Kenneth L · Pomona, CABuilt 1973 · S/N 310Q0977N6817TErickson Paul M · Okahumpka, FLS/N 39117N6821TCollard George E · Bountiful, UTBuilt 1960 · S/N 39121N6823TSpaulding Rod D · Atascadero, CABuilt 1960 · S/N 39123N6824TDoc'S Flight Training LLC · Prescott, AZBuilt 1960 · S/N 39124N6826TPetecraft Aviation Services Inc · Plains, GABuilt 1960 · S/N 39126N6827TLordemann Eric P · Petersburg, NES/N 39127N6838XOcean Flight Corp · Weston, FLBuilt 1978 · S/N 402B1346N6877TBeedy Lyle G · Derby, KSBuilt 1960 · S/N 39177N688SPSanchez Eddy B · Miami Gardens, FLS/N 402B0603N688WGDebritton Daniel R · Tustin, CABuilt 1957 · S/N 35613N6893TJurn Paul · Sandusky, MIBuilt 1960 · S/N 39193N6898TMoore Albert Jr · Indianapolis, INBuilt 1960 · S/N 39198N689DCSirek David G · Fritch, TXBuilt 1960 · S/N 39068N68EAerometal International Inc · Aurora, ORS/N 35383N68RDWilliams Gerald L · Malibu, CABuilt 1965 · S/N 320D0026N68WAChuss Edward J · Metamora, MIBuilt 1968 · S/N 421-0137N6906TReid Brian M · Boise, IDBuilt 1960 · S/N 39206N6910LN6910l LLC · Yucca Valley, CABuilt 1966 · S/N 310K0010N6914LC2 Holdings 22 LLC · Chesapeake, VABuilt 1965 · S/N 310K0014N6919LJohnson Alan D · Prior Lake, MNBuilt 1965 · S/N 310K0019N6920LGlen Air Inc · Powder Springs, GAS/N 310K0020N6922LMontana Air Service · Big Timber, MTBuilt 1965 · S/N 310K0022
Back to AD 72-14-08 R1