OpenAirDocs.org
AD 72-03-03 R3

Registered aircraft · 17,027

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-03-03-R3')
    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-03-03-R3')
  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.

N74177Campbell Peter Shane · Knoxville, TNBuilt 1974 · S/N 177RG0481N7419GFlycarolina LLC · Concord, NCBuilt 1970 · S/N 17259119N741GSReform Friendly Flyers LLC · Buhl, ALBuilt 1970 · S/N 17259111N7420GKellum Richard A · Seattle, WABuilt 1970 · S/N 17259120N7421GLibby Matthew P · Castle Hill, MEBuilt 1970 · S/N 17259121N7422GLafayette Escadrille Flying Club · Rock Spring, GABuilt 1970 · S/N 17259122N7425GSmoke Eagles Inc · Downey, CABuilt 1970 · S/N 17259125N7426GProvoncha Tina · Oak Harbor, WABuilt 1970 · S/N 17259126N7427GWilliams Jason R · Cordova, TNBuilt 1970 · S/N 17259127N7429GDiditair Inc · Knoxville, TNBuilt 1970 · S/N 17259129N7432GNichols Roy D · Cadillac, MIBuilt 1970 · S/N 17259132N7433GStyles Brian P · Cullman, ALBuilt 1970 · S/N 17259133N7436GChickadee Aviation LLC · Rangeley, MEBuilt 1970 · S/N 17259136N7438GMcguinnis Joseph G · Scottsdale, AZBuilt 1973 · S/N 15074655N7439GScheck Doug J · Medina, OHBuilt 1970 · S/N 17259139N743HLanoue Edgar A · Stevensville, MTBuilt 1969 · S/N U206-1297N743RBBenefield Shelby · Attalla, ALS/N 15072497N7440GJohnes Charles H · Santa Maria, CABuilt 1973 · S/N 15074656N7441GSussex Aero Maintenance Inc · Georgetown, DEBuilt 1970 · S/N 17259141N7447NJc Flight Inc · Wilmington, DEBuilt 1966 · S/N F1720311N7449GAvmajic LLC · Waterford, MIBuilt 1970 · S/N 17259149N744DPAviation Components Inc · Tarzana, CABuilt 1968 · S/N 18258929N7450GLewis Benjamin · Delano, MNBuilt 1970 · S/N 17259150N7451GPresto William R · Houston, PABuilt 1973 · S/N 15074660N7453GNorthwoods Flyer LLC · Jacksonville, FLBuilt 1970 · S/N 17259153N7454GDaniel Dewey R · Okeechobee, FLBuilt 1970 · S/N 17259154N745KPPaklook Air Inc Dbi · Bethel, AKFirst renewal noticeBuilt 1974 · S/N 20700238N745XColson Troy D · Crystal River, FLBuilt 1968 · S/N 18258933N7461GKniphfer Krenson Hunter · Newington, GABuilt 1970 · S/N 17259161N7465GLaird Charles A · West Chester, PABuilt 1970 · S/N 17259165N746DGVolkernick Peter A · Rumford, MEBuilt 1966 · S/N 15065758N7471GKyle Allyn B · Snohomish, WABuilt 1973 · S/N 15074664N7474GBarnett Kevin · Simi Valley, CABuilt 1970 · S/N 17259174N7478GMckinney Brian M · Lakeville, MNS/N 17259178N7479GLebanon Flying Club Inc · Lebanon, TNBuilt 1970 · S/N 17259179N747GBBrogan Kenneth A Jr · Montesano, WABuilt 1972 · S/N 17259440N747KYMahany John S · Long Beach, CABuilt 1970 · S/N 15071860N747LPSimplifly LLC · Mesa, AZBuilt 1971 · S/N 17260272N747MLMaxwell Robert C · Fountain Hills, AZBuilt 1975 · S/N 177RG0719N747PMVko Llp · Custer, SDBuilt 1969 · S/N 18259564N747WGWhiskey Gulf Aero LLC · Deland, FLBuilt 1968 · S/N 18259186N7480GPage Ralph W · Jennings, LABuilt 1970 · S/N 17259180N7481GUncapher Elmer D · Mendon, OHS/N 17259181N7485GIndependent Aviation Services LLC · Sachse, TXBuilt 1970 · S/N 17259185N7486SGarage Doors Of Greenville LLC · Greenville, MSBuilt 1969 · S/N 15070358N7487GRich Aviation Services LLC · Fort Worth, TXBuilt 1970 · S/N 17259187N7489GCloud Fleet Aviation LLC · Fort Lauderdale, FLBuilt 1970 · S/N 17259189N7491GAccess Air Service Inc · Mercedita, PRBuilt 1970 · S/N 17259191N7493GHaugo Robert P · Scobey, MTBuilt 1970 · S/N 17259193N74ALDavis Tessie · Buckeye, AZBuilt 1974 · S/N 15075510
Back to AD 72-03-03 R3