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.

N7060SDygas Pauel · Pomerene, AZS/N 15067760N70616Washburn Darlene J · Newberg, ORBuilt 1968 · S/N 18259326N70617Mcnutt John W · Seattle, WABuilt 1968 · S/N 18259327N70618Allen Steven P · Flagstaff, AZBuilt 1968 · S/N 18259328N7061QMccutcheon Henry C · Frankfort, KYBuilt 1972 · S/N 17260361N7061SDirar Farras S E · Sackets Harbor, NYBuilt 1967 · S/N 15067761N7062Carvagno Lawrence · Trinity, ALS/N 18260264N70625Resong Joseph J · Garden Grove, CABuilt 1968 · S/N 18259331N7062GNorthwoods Aviation LLC · Eagle River, WIS/N 17258762N7062SPrecision Aerospace Corp · Sarasota, FLBuilt 1967 · S/N 15067762N70632Galion Air Inc · Galion, OHBuilt 1968 · S/N 18259332N70633North County Flying Club · Tehachapi, CAFirst renewal noticeBuilt 1968 · S/N 18259333N70634Sowry Myron E · Phillipsburg, OHBuilt 1968 · S/N 18259334N70635Sitatunga Springs LLC · River Hills, WIBuilt 1968 · S/N 18259335N7063GL A H Eickhoff Farms Inc · Falls City, NEBuilt 1969 · S/N 17258763N7063QCarver Clarence K · Lutz, FLS/N 17260363N70649Carroll Aviation Inc · Carroll, IABuilt 1968 · S/N 18259341N7064SCuddington Mark E · Puyallup, WAS/N 15067764N70651Sale Reported · Lakewood, COSale reportedBuilt 1968 · S/N 18259342N70655Kusterer James E Jr · Nampa, IDBuilt 1968 · S/N 18259343N70657Cobra Kai Inc · Wichita Falls, TXBuilt 1968 · S/N 18259344N70658Vroom David H · Oro Valley, AZBuilt 1968 · S/N 18259345N7065GAden David L · Keenesburg, COBuilt 1969 · S/N 17258765N7065JAmendt Inc · Sedgwick, COS/N 18257772N7066FLamb Barry J · Moran, KSBuilt 1966 · S/N 15063666N7066GSwindle Don K · Collinsville, TXBuilt 1969 · S/N 17258766N7067GAngelle Kelli R · New Roads, LABuilt 1969 · S/N 17258767N70686Haase Douglas R · Manassas, VABuilt 1968 · S/N 18259356N70688Roesner David A · Salina, KSBuilt 1968 · S/N 18259358N7068FAndrew David N · Manhattan, ILBuilt 1966 · S/N 15063668N7068QWestwind Aviation Inc · Bremerton, WABuilt 1972 · S/N 17260368N70695Tucker Whitney L · Gove, KSBuilt 1968 · S/N 18259360N70697Whalen Charles R · Gladewater, TXS/N 18259362N70698Martin Kenneth R · Mill Creek, WABuilt 1968 · S/N 18259363N7069GAjf Enterprises LLC · Des Moines, IABuilt 1969 · S/N 17258769N7069QFlakker Michael E · Gold Hill, NCS/N 17260369N706PREvoaviation LLC · Watkinsville, GABuilt 1971 · S/N 18260752N7070FDaub David M · Sealy, TXBuilt 1966 · S/N 15063670N7070GGade Christopher P · Williston, VTFirst renewal noticeBuilt 1969 · S/N 17258770N70710Embyr November LLC · Gunnison, COBuilt 1968 · S/N 18259364N7071GWings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258771N7071QSun Country Aero Club · The Villages, FLS/N 17260371N7072FMiller Richard M · New Galilee, PABuilt 1966 · S/N 15063672N7072GMears Benjamin W III · Eastville, VABuilt 1969 · S/N 17258772N7072QB&R Aircraft LLC · Wadsworth, OHS/N 17260372N7072SEstby Hans P · Hayfield, MNBuilt 1967 · S/N 15067772N7073FBushby David R · Barnesville, GABuilt 1966 · S/N 15063673N7073GSky Warriors LLC · Hayward, CAS/N 17258773N70740Sierra Bravo Air LLC · Winston Salem, NCBuilt 1968 · S/N 18259365N7074SBoening Bros Dust & Spray Svc · Floresville, TXBuilt 1967 · S/N 15067774
Back to AD 72-03-03 R3