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.

N373KVCrystalinas Johnathan · Rancho Cordova, CABuilt 1966 · S/N 15064401N3740FLavalley Asset Management · Potsdam, NYBuilt 1966 · S/N 17255235N3740JHersom Jeffrey T · Helena, MTBuilt 1966 · S/N 15065040N3740RRhodes Samuel R · Bonne Terre, MOBuilt 1967 · S/N 17255540N3740UFlight Club 502 Inc · Louisville, KYBuilt 1963 · S/N 18255140N3741FMclanahan John P · Culpeper, VAS/N 17255236N3741JSharp Ruth · Clarksville, TNBuilt 1966 · S/N 15065041N3741RAbecca Corp · Jackson, MIBuilt 1966 · S/N 17255541N3742JLow Cost Flying LLC · Chandler, AZBuilt 1966 · S/N 15065042N3743FRohde William B · Homer, NEFirst renewal noticeBuilt 1966 · S/N 17255238N3743LAero Flight Two LLC · Peoria, AZS/N 17253912N3743UHughes Kathryn G · Council, IDBuilt 1963 · S/N 18255143N3743YCooper Jess D · Spanaway, WAS/N 21058243N3744LAir Jeffery LLC · Aledo, TXBuilt 1965 · S/N 17253913N3745LMaxey Lonnie C · Powell, TNBuilt 1965 · S/N 17253914N3745RDodds Timothy E · Salmon, IDBuilt 1966 · S/N 17255545N3745UAnglemyer Mark · Piketon, OHBuilt 1963 · S/N 18255145N3746JCrandall Lloyd G · Lake City, MIBuilt 1966 · S/N 15065046N3746LBygd Sherman O · New Richmond, WIBuilt 1965 · S/N 17253915N3746RPearson Eric · Wills Point, TXS/N 17255546N3746UUltimate Internet Access Inc · Wrightwood, CABuilt 1963 · S/N 18255146N3746YWeed James A · Suwanee, GABuilt 1963 · S/N 21058246N3747JRegistration Pending · Bay Harbor Islands, FLRegistration pendingS/N 15065047N3747LN3747l LLC · Sonora, CABuilt 1965 · S/N 17253916N3747YCenturion Aviation Nevada LLC · Sparks, NVBuilt 1963 · S/N 21058247N3748FMcdonald David R · Duluth, MNS/N 17255243N3748HVoth Michael K · Lynchburg, VABuilt 1963 · S/N 21058248N3748RRotormate LLC · Royse City, TXBuilt 1966 · S/N 17255548N3748UChristy Allen C · Farmington, NMBuilt 1963 · S/N 18255148N3749FLeduc Kramer LLC · Live Oak, FLBuilt 1966 · S/N 17255244N3749JLove Duane Anthony · San Rafael, CAFirst renewal noticeBuilt 1966 · S/N 15065049N3749LWilcox James F · Garrison, NDBuilt 1965 · S/N 17253918N3749YWestwind Homes Inc · Twin Falls, IDBuilt 1963 · S/N 21058249N3750FGrubbs Richard T · Spring, TXBuilt 1966 · S/N 17255245N3750JEagle East Aviation Inc · North Andover, MABuilt 1966 · S/N 15065050N3750RN3750r LLC · Guthrie, OKBuilt 1966 · S/N 17255550N3750YMurphy Mark · Belleair, FLBuilt 1963 · S/N 21058250N3752FCopper River Airmotive LLC · Copper Center, AKS/N 17255247N3752JLudwig Daniel C · New Rockford, NDBuilt 1966 · S/N 15065052N3752RMccoy Gregory K · Wichita, KSBuilt 1966 · S/N 17255552N3752URegistered aircraftBuilt 1963 · S/N 18255152N3753JWallin Joshua M · Moreno Valley, CAS/N 15065053N3753LKroutil David W · Hilmar, CABuilt 1965 · S/N 17253922N3753RCounts Sean M · Largo, FLBuilt 1966 · S/N 17255553N3753YWolfe Christopher D · Gilbert, AZBuilt 1963 · S/N 21058253N3754FTrees Joshua S · Italy, TXBuilt 1966 · S/N 17255249N3754LBuist Gordon G · Southbury, CTBuilt 1965 · S/N 17253923N3754RVandiver James A · Rome City, INBuilt 1966 · S/N 17255554N3754YSullivan Eugene M · Cotter, ARBuilt 1963 · S/N 21058254N3755LNorcal Flight Center LLC · Lincoln, CAS/N 17253924
Back to AD 72-03-03 R3