OpenAirDocs.org
AD 72-02-06

Registered aircraft · 2,299

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-02-06')
    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-02-06')
  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.

N101PQValiair Limited Company Trustee · Casper, WYBuilt 1962 · S/N 21057932N102BMeyjes Gijsbert Posthumus · Cadillac, MIS/N 337-0024N104BU1984k LLC · Gypsum, COS/N 18254352N108CCFlaugher Jonathan S · Poquoson, VABuilt 1965 · S/N 3370202N109HBadke Paul J · Ray, MIBuilt 1962 · S/N 21057921N10CCSmith Kord S · Salmon, IDBuilt 1964 · S/N 206-0166N10RVKoehn Shane Michael · Scooba, MSBuilt 1964 · S/N 21058418N110FSMaggie L Air Service LLC · Kalispell, MTS/N 18256604N110SMPenhall Michael Joseph · Lake Forest, CABuilt 1964 · S/N 337-0023N111NJNew Jersey Forest Fire Service · Trenton, NJBuilt 1964 · S/N U206-0278N112VBHatley Ralph A · Eagle Creek, ORBuilt 1963 · S/N 18254937N113BSHill Jason A · Cody, WYBuilt 1964 · S/N 18255205N11BTBravo Tango LLC · Minden, LABuilt 1965 · S/N 18256146N11DZLowe Jacob · Knoxville, TNBuilt 1965 · S/N 18256245N1205BEngel Shane J · Willow, AKBuilt 1963 · S/N 205-0190N12077Crawley Michael P · Penn Valley, CABuilt 1965 · S/N 18255966N123KTHolliday Paul B · Kiln, MSBuilt 1963 · S/N 21058218N123VJKopp Daniel D · Buckeye, AZBuilt 1965 · S/N 18256102N123WGThornhill Shaun · Greenville, OHBuilt 1963 · S/N 18254997N125TLPease Lynn A · Elizabeth, ILS/N 18255291N1290KN1290k LLC · Dover, DEBuilt 1965 · S/N 18256650N1291PPowers Elbie L · Roseboro, NCBuilt 1965 · S/N 18256573N1302GDarby Patricia Petosky · Midland, TXBuilt 1964 · S/N 18255562N1344UGrit Services LLC · Manila, ARBuilt 1962 · S/N 18254544N135FPointon Aviation LLC · Baraboo, WIBuilt 1965 · S/N 18256502N136JRaichl John P · Astoria, ORBuilt 1962 · S/N 205-0136N137MCPoland Gilbert Guardian · Dothan, ALBuilt 1965 · S/N 337-0127N13BJSevcik Clint · Medford, MNS/N 21058486N142RSReinmuth Michael W · Lopez Island, WAS/N 18253832N143DBBernard Daniel · GrillyBuilt 1965 · S/N 18256678N143JBKing John · Torrance, CABuilt 1965 · S/N 337-0102N143TCHarris William D · Topeka, KSBuilt 1962 · S/N 205-0064N14472Hoerler Jonathan · Lincoln, ARBuilt 1963 · S/N 18255194N145PPainter Bryan J · Renton, WABuilt 1963 · S/N 205-0332N14872Blumenthal James R · Kingman, AZBuilt 1973 · S/N U20602144N14MDDaniel Development LLC · Durango, COBuilt 1962 · S/N 18254114N1505TN1505t LLC · Tucson, AZBuilt 1966 · S/N P206-0212N152PHahn Tacy W · Nevada City, CABuilt 1963 · S/N 18255080N155KTN155kt LLC · Dover, DEBuilt 1963 · S/N 21058196N156AEHolt Cory J · Santa Ynez, CABuilt 1962 · S/N 18254549N160PYeager Robert F · Cuyahoga Falls, OHBuilt 1962 · S/N 18254278N165WFHardin John M · Terrell, TXBuilt 1962 · S/N 210-57875N168AERobinson Kevin B · Texarkana, TXBuilt 1963 · S/N 18255158N169JABixby & Sons LLC · Vale, ORBuilt 1964 · S/N 18256004N16HTAviation Specialties Unlimited Inc · Boise, IDBuilt 1964 · S/N 2060134N1724THanna David B · Tonasket, WABuilt 1964 · S/N 21058360N1748ZRanz Douglas R · West Bloomfield, MIBuilt 1962 · S/N 205-0047N178ZLUsda Forest Service Fepp · Columbia, SCBuilt 1963 · S/N 18254850N17TCKenyon Walter C · Eureka Springs, ARBuilt 1964 · S/N 21058499N1800FReid Brian M · Boise, IDBuilt 1965 · S/N 21058700
Back to AD 72-02-06