OpenAirDocs.org
AD 72-03-03 R3

Registered aircraft · 17,028

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.

N8218USalley Ronald C · Satellite Beach, FLBuilt 1964 · S/N 17252118N8219FKietzer Tyler L · Mankato, MNS/N 15064319N8219GSchaum Jerome B · Machipongo, VABuilt 1971 · S/N 177RG0119N8219MFair Winds Group LLC · Portage, MIBuilt 1969 · S/N 21059219N8219UShaffer Kenneth H · Trout Lake, WABuilt 1964 · S/N 17252119N821RMC&C Aero LLC · Billings, MTBuilt 1967 · S/N 17256414N8220LFlywyo LLC · Kalispell, MTBuilt 1967 · S/N 17256420N8220SHammack Lindsey M · Westlake, TXBuilt 1965 · S/N 15061820N8221FSale Reported · Eau Claire, MISale reportedBuilt 1966 · S/N 15064321N8221GIshoy Glen · Indiana, PABuilt 1971 · S/N 177RG0121N8221LAntholz John C · Apple Valley, MNBuilt 1967 · S/N 17256421N8221ZHaralson Douglas K · Kenai, AKBuilt 1963 · S/N 205-0221N8222LSimpson Roger E Sr · Moncks Corner, SCBuilt 1967 · S/N 17256422N8222MFrank Sherril P · Grapevine, TXBuilt 1969 · S/N 21059222N8222UCramer Bill · Oxnard, CABuilt 1964 · S/N 17252122N8223FSoderman David W · Gilby, NDBuilt 1966 · S/N 15064323N8223LO'Connor Aidan J · East Moriches, NYBuilt 1967 · S/N 17256423N8223SRedditt William L · Erie, PABuilt 1965 · S/N 15061823N8223UChapter 36 Flying Club Inc · Hagerstown, MDBuilt 1964 · S/N 17252123N8224FDiamond David Z · Wrentham, MABuilt 1966 · S/N 15064324N8224GSkylarkers Inc · Farmington, NMBuilt 1971 · S/N 177RG0124N8224LCamp Lake Aircraft LLC · Salem Lakes, WIBuilt 1967 · S/N 17256424N8224UPlane Fun Inc Tr Trustee · Snellville, GABuilt 1964 · S/N 17252124N8224ZGloria Glenn Inc DBA · Roswell, NMFirst renewal noticeBuilt 1963 · S/N 205-0224N8225HLout James M · Jasper, TXS/N 18260681N8225LWebb George Q · Monroe, GAS/N 17256425N8225MCarlson Farms Inc · Plentywood, MTBuilt 1969 · S/N 21059225N8225YInternational Air Services Inc Trustee · Carson City, NVFirst renewal noticeBuilt 1977 · S/N 177RG1247N8226FPrahin Michael H · Novi, MIBuilt 1966 · S/N 15064326N8227GKritz Eric J · Gualala, CABuilt 1971 · S/N 177RG0127N8227SKashani Asher Farzan · Reseda, CABuilt 1965 · S/N 15061827N8227UGeiger Russell K · Hilliard, FLBuilt 1964 · S/N 17252127N8227ZGa 27z LLC · Arlington, WABuilt 1963 · S/N 205-0227N8228Cross John · Canton, OHBuilt 1965 · S/N 17252520N8228SMorristown Flying Service Inc · Talbott, TNS/N 15061828N8229GEastman Gary Lynn · Penn Valley, CABuilt 1971 · S/N 177RG0129N8229LWuest Steven D · Ripon, WIBuilt 1967 · S/N 17256429N8229MOlsen Frances K · Bostwick, GABuilt 1969 · S/N 21059229N8229SShanaman Baratt S · Ann Arbor, MIBuilt 1965 · S/N 15061829N8229UBurmeister James · Roseville, CABuilt 1964 · S/N 17252129N822CGRepublic Wings LLC · Moseley, VABuilt 1976 · S/N 177RG1031N8230LBridle Bit Ranch Co · Gillette, WYBuilt 1967 · S/N 17256430N8231FNeuman Paul · Campbellsburg, KYBuilt 1966 · S/N 15064331N8231GRad Pouria · Camarillo, CABuilt 1971 · S/N 177RG0131N8231ZChamberlain C Douglas · Bellefontaine, OHBuilt 1963 · S/N 205-0231N8232FSouthern Arkansas University Tech · Camden, ARBuilt 1966 · S/N 15064332N8232ZWittber John R · Memphis, TNS/N 205-0232N8233LKensinger Steve · North Pekin, ILS/N 17256433N8233MSixty Nine Kilo LLC · Oakland, CABuilt 1969 · S/N 21059233N8233ZLarky Brian L · Napa, CABuilt 1963 · S/N 205-0233
Back to AD 72-03-03 R3