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.

N5996MMedcare Emergency Medical Services Inc · Mcallen, TXBuilt 1972 · S/N 421B0334N59DJBruce Matthew B · Arlington, TXBuilt 1959 · S/N 35915N59MRFly Bravo LLC · Jasper, TXBuilt 1959 · S/N 35929N59NMGf Air LLC · Las Vegas, NVBuilt 1975 · S/N 421B0870N59RLBurton Donald O · Mooresville, NCBuilt 1959 · S/N 35946N59TGT Stanco Inc · Jasper, GAS/N 35792N5CHHartshorn William T · Tucson, AZBuilt 1968 · S/N 421-0113N5HSRose Raymond P · San Diego, CABuilt 1962 · S/N 320A0026N5LHIsland Creek Partners LLC · Alpine, CABuilt 1973 · S/N 310Q0939N5PJGod Family Ministries International Inc · Elmont, NYBuilt 1972 · S/N 421B-0258N5VXParrott Land & Cattle LLC · Roundup, MTBuilt 1958 · S/N 35797N5YFBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 310L-0084N600EXAire Tracks Corp · Wilmington, DEBuilt 1969 · S/N 310P0147N600RRCompac Inc · Manassas, VABuilt 1963 · S/N 310H0108N600SMCapt Tony 185 LLC · Aurora, COBuilt 1966 · S/N 320E0084N60FYNew Castle Aviation Inc · Durham, NHBuilt 1969 · S/N 310P0109N610AKBaja Electric Service Inc · Punta Gorda, FLBuilt 1974 · S/N 310Q-1072N610RCHallada William A · Barnesville, GAS/N 310-0115N611UParker Robert T Jr · Bigfork, MTS/N 35106N612CGCasa Grande Homes Inc · Blanchard, OKBuilt 1973 · S/N 421B0416N612JPSkyline Air LLC · Ashburn, VABuilt 1968 · S/N 310N-0116N6151QNitro Zeus Inc · Wilmington, DEBuilt 1967 · S/N 320F-0001N6156QGem State Transportation Inc · Hamilton, MTBuilt 1967 · S/N 320F-0006N616DFugate Kirk A · El Dorado Springs, MOS/N 421B0140N6184QMarc Inc · Bolton, MSBuilt 1968 · S/N 320F-0034N6193QRedstar Air Shows Inc · Discovery Bay, CABuilt 1968 · S/N 320F-0043N6194ZNeel Aviation LLC · Lakeland, FLS/N 35378N6195QSunny Aviation LLC · Kalispell, MTBuilt 1968 · S/N 320F-0045N61DSHouston Aeronautical Heritage Society Inc · Houston, TXS/N 35317N61RWAerial Services Inc · Cedar Falls, IABuilt 1966 · S/N 320E0001N620JPPreiss Aviation Inc · Poplar Grove, ILBuilt 1972 · S/N 310Q0639N622LPClear Skies Avionics Inc · Clearwater, FLS/N 310L-0131N6249QKnudsen Russell G · East Troy, WIBuilt 1969 · S/N 401A0049N624CAClarke Cecil Jr Trustee · Katy, TXBuilt 1975 · S/N 402B0876N624PKBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 421B0144N6255QValiair Limited Company Trustee · Casper, WYBuilt 1969 · S/N 401A0055N6268QChuss Edward J · Metamora, MIS/N 310Q0526N6272TBernaiche Travis · Caribou, MEBuilt 1969 · S/N 421A0141N6277QFly Me LLC · Sparta, TNBuilt 1973 · S/N 310Q0747N6283QOn Glidepath Properties LLC · Gilbert, AZBuilt 1972 · S/N 310Q0492N628RJJanak Jeffrey · Corpus Christi, TXBuilt 1974 · S/N 421B-0503N62DWSagamore Sky LLC · Jericho, NYS/N 4210188N631FHayes Terry E · Rockport, TXBuilt 1963 · S/N 39169N635RRobertello Gerald W · Centreville, VABuilt 1955 · S/N 35092N6375XMiliano Air LLC · Lewes, DEBuilt 1978 · S/N 402B1338N6384XPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1978 · S/N 402B1347N6387XAir Exec Inc · Mount Pleasant, IABuilt 1978 · S/N 402B1350N6396XAviation Tech Services LLC · Edgewater, FLBuilt 1978 · S/N 402B1355N639FTotal Generator Service Inc · Strafford, MOBuilt 1956 · S/N 35400N639SCSale Reported · Glen Allen, VASale reportedBuilt 1969 · S/N 421A0102
Back to AD 72-14-08 R1