OpenAirDocs.org
AD 72-20-02

Registered aircraft · 4,864

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

N1000LWise Joe · Kilgore, TXBuilt 1966 · S/N TC-1000N1000NAnderson Aerial Spraying Service Inc · Canby, MNBuilt 1963 · S/N 310H0104N1000QErnest Obregon · Oakley, CAS/N 310P0195N1001QRegistered aircraftBuilt 1962 · S/N 310H0001N1002QSwanson Dale A · Nashua, NHBuilt 1962 · S/N 310H0002N1005QRegistration Pending · Fairmont, WVRegistration pendingS/N 310H0005N1007F007 Aviation LLC · Wilmington, DEBuilt 1968 · S/N TC-1163N1009QWatson James E Jr · Victor, COBuilt 1962 · S/N 310H0009N100BMarshall Xavier T · Carson, CAS/N 57114N100FBHoffman Swen · Sedalia, COBuilt 1963 · S/N D-7158N100GMHuguenard Jefferson J · Alpharetta, GABuilt 1968 · S/N TC-1183N100JHSonic Aviation LLC · Carrollton, MSBuilt 1971 · S/N 310Q0421N100TBAlexander Aviation LLC · Brighton, COBuilt 1963 · S/N CD-637N100TGBengtson Todd · Tyler, TXBuilt 1974 · S/N 310Q1150N100ZPZipjack Inc · Fernandina Beach, FLBuilt 1955 · S/N BG-4N100ZZArbuckle George A · Poolville, TXBuilt 1975 · S/N TC-1922N1015QMayo William J Jr · Reed Point, MTBuilt 1962 · S/N 310H0015N101BBPolson Taylor M · Killeen, TXBuilt 1959 · S/N D-6076N101HTWilder Bart M · Maryville, TNBuilt 1958 · S/N D-5722N101PQValiair Limited Company Trustee · Casper, WYBuilt 1962 · S/N 21057932N1024Calgonaire LLC · Seminole, TXS/N 57425N1028WArt Air Partners LLC · Louisburg, NCBuilt 1973 · S/N TC-1533N102FAMedic Choppers LLC · Springdale, ARS/N TC-483N102JRRutkosky John J DBA · Palm Coast, FLBuilt 1961 · S/N 310-0041N102XRidley Benjamin · Jamesville, NYBuilt 1966 · S/N 310L-0034N1040TTen Forty Tango LLC · Wichita, KSBuilt 1962 · S/N TC-318N1042RSale Reported · Los Angeles, CASale reportedBuilt 1971 · S/N TC-1414N1045QWolf Mark W · Long Lake, MNBuilt 1963 · S/N 310H0045N1045WButler Richard S · Poplar Grove, ILBuilt 1973 · S/N TC-1535N1046QAcharya Jay P · Powell Butte, ORS/N 310H0046N1047W1047w LLC · Oakland, TNBuilt 1973 · S/N TC-1536N104MMBaron 104mm LLC · Rohnert Park, CABuilt 1962 · S/N TC-289N1052QNighthawk Air Systems Inc · Miami, FLS/N 310H0052N1056QAerotrack Inc · Hemet, CABuilt 1963 · S/N 310H0056N105BCKlauber Robert A · Athens, TNBuilt 1966 · S/N 310K0232N105FADebbie Air LLC · Perkasie, PABuilt 1965 · S/N CD-853N105LRegistered aircraftBuilt 1959 · S/N 35981N105MCMathison John M · Del Norte, COBuilt 1964 · S/N 310I0162N105XSaalwaechter John J · Lebanon, INBuilt 1960 · S/N D-6436N1060WHarvey Ara Jr · Hernando, MSBuilt 1973 · S/N TC-1539N106VKenyon Joseph S · Fort Collins, COBuilt 1959 · S/N D-6009N10712Hall Air Inc · Weiner, ARBuilt 1961 · S/N TC-59N1073QRegistration Pending · Polo, MORegistration pendingBuilt 1963 · S/N 310H0073N1079QGriffin Marcus · Houston, TXBuilt 1963 · S/N 310H0079N107SWanagel Walter · Lisbon, CTBuilt 1949 · S/N NAV-4-1946N107VWHenning Nancy E · Hardinsburg, KYBuilt 1960 · S/N CD-71N1083QAhlhorn Travis W · San Marcos, TXBuilt 1963 · S/N 310H0083N108GBLooney Jordan · Trumann, ARBuilt 1960 · S/N D-6422N108JHInternational Air Services Inc Trustee · Carson City, NVS/N TC-1530N108MLosey Thomas L · Ft Myers, FLBuilt 1963 · S/N 281
Back to AD 72-20-02