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.

N5788XMcmahan William K · Sandy Valley, NVBuilt 1962 · S/N 320-0088N5793XSchmick Kenneth Richard · Fond Du Lac, WIS/N 320-0093N5794MMatlach Matthew · Brandon, FLBuilt 1969 · S/N 310P0094N57BWNorthwoods Airlifeline Ltd · Kingsford, MIBuilt 1968 · S/N 310N-0154N5806XJohnson Joseph S · Juneau, AKBuilt 1961 · S/N 310-0106N5812XAll-Bid Inc · Opelousas, LABuilt 1961 · S/N 310-0112N5814XEberly Steven K · Euless, TXBuilt 1961 · S/N 310-0114N5816MHolloway Aero LLC · Chino Hills, CAS/N 310P0116N5817MHonan William · Rainbow City, ALBuilt 1969 · S/N 310P0117N5818MGlidepath Aviation LLC · West Jordan, UTBuilt 1969 · S/N 310P0118N5819MJones Kathleen W · Springfield, ORBuilt 1969 · S/N 310P0119N581CJDodson International Parts Inc · Rantoul, KSS/N 421B0343N5821MMarc Inc · Bolton, MSBuilt 1969 · S/N 310P0121N5822XTas Aviation Of Defiance Inc · Defiance, OHBuilt 1961 · S/N 310-0122N5827XBechtold Norman J · Claremore, OKBuilt 1961 · S/N 3100127N5833XOttley Adam James · Montague, CAS/N 310-0133N583DWKinetic Systems Inc · Richmond Hill, GABuilt 1973 · S/N 421B0583N5843XPierson Janice R Trustee · Scio, ORS/N 310-0143N5845MPointhigh Partners Lp · Dallas, TXBuilt 1969 · S/N 310P0145N5845XCranton Larry J · Mesa, AZBuilt 1961 · S/N 310-0145N5850MJones Michael J · Cypress, TXBuilt 1969 · S/N 310P0150N5853XAnderson Douglas S · Gansevoort, NYBuilt 1961 · S/N 310-0153N5854MJantzen Equipment LLC · Madrid, NEBuilt 1969 · S/N 310P0154N5857MVenturi Corp · Staunton, ILBuilt 1969 · S/N 310P0157N5862MPortland Holdings LLC · Vista, CABuilt 1969 · S/N 310P0162N586JRHuerta Holdings Inc · Santa Ana, CABuilt 1969 · S/N 310P0165N5872MDixon Jack · Casa Grande, AZBuilt 1969 · S/N 310P0172N5874CVola Acosta LLC · Lake Forest, CAS/N 421C0882N5877MBrook Ash Inc · Waxahachie, TXS/N 310P0177N587MWHammonds Mark · N Richlnd Hls, TXBuilt 1974 · S/N 421B0587N5882TDe Smet Vicki M · La Verne, CAS/N 421B0424N5885MButler Richard A · Portland, TXBuilt 1969 · S/N 310P0185N588DMColeman Russell Ll · Saint Charles, ILBuilt 1973 · S/N 310Q0624N588RRGay Don F · Terrell, TXBuilt 1966 · S/N 310K0091N589DMGeorgescu Radu A · Louisville, KYS/N 310Q1048N590FMTrrek Enterprises LLC · Sunriver, ORBuilt 1966 · S/N 320D0095N5911MYataco Enrique · Dothan, ALS/N 310P0211N5913MWallace Larry Wayne · Millsap, TXBuilt 1969 · S/N 310P0213N5914MBogie Aviation LLC · Newton, NJBuilt 1969 · S/N 310P0214N5916MQuest Aviation Inc · Lake City, FLBuilt 1973 · S/N 402B0365N5925MDickerson Stephen R · Frisco, TXBuilt 1969 · S/N 310P0225N5933MMonahan Robert J · Bulverde, TXBuilt 1969 · S/N 310P0233N5934M34m LLC · Young Harris, GABuilt 1969 · S/N 310P0234N593DMLister John · Pipe Creek, TXS/N 402B1228N5949MSnflk Leasing LLC · Andrews, TXBuilt 1972 · S/N 421B0319N594WBUintacor Inc · Mesa, AZS/N 310Q0077N5951MMcdonnell Enterprises Inc · Wilmington, DEBuilt 1973 · S/N 310Q0737N5962MKitov Resources Corp · Shorewood, WIS/N 421B0205N5967MN5967m LLC · Chantilly, VAS/N 421B0210N5988MSaltzer Eric · Somerton, AZBuilt 1972 · S/N 421B0231
Back to AD 72-14-08 R1