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.

N8201GMetzgen Richard A · Groveland, CABuilt 1971 · S/N 177RG0101N8201LLonghorn Fligh Training LLC · Midlothian, TXBuilt 1967 · S/N 17256401N8201SMann Derek W · Burwell, NEBuilt 1965 · S/N 15061801N8201ULerma Homero G · Mcallen, TXBuilt 1964 · S/N 17252101N8202F98x LLC · Caddo Mills, TXBuilt 1966 · S/N 15064302N8202LHorizon Flights Corp · Henderson, NVNon-citizen corporation, flight hours not reportedBuilt 1967 · S/N 17256402N8202SBell Tammy L · San Antonio, TXS/N 15061802N8202UBudget Flyers · Shreveport, LABuilt 1964 · S/N 17252102N8203GWarne Samuel S · Salisbury, NCBuilt 1971 · S/N 177RG0103N8203MBottle Meister Inc · San Luis Obispo, CABuilt 1969 · S/N 21059203N8204GLowe Clinton V · Lake Point, UTBuilt 1971 · S/N 177RG0104N8204LJohnson Kathy L · Wellsburg, WVBuilt 1967 · S/N 17256404N8204USchenck Paul · Glendale, CAS/N 17252104N8204ZLfs Inc · Ekalaka, MTFirst renewal noticeBuilt 1963 · S/N 205-0204N8205FRegistered aircraftBuilt 1966 · S/N 15064305N8205SMckay Christopher · Point Arena, CAS/N 15061805N8205UDby Flights LLC · Pennock, MNBuilt 1964 · S/N 17252105N8205ZMcdaniel George C · Mission Viejo, CABuilt 1963 · S/N 205-0205N8206LPratt Errol C · Fayetteville, GABuilt 1967 · S/N 17256406N8206UShortridge Gary F · Dover, TNBuilt 1964 · S/N 17252106N8206ZMadson Barry L · Dayton, NVBuilt 1963 · S/N 205-0206N8207BBodin Logan T · Lake Charles, LAS/N 15069004N8207FChantry Terrell A · Lake Havasu City, AZFirst renewal noticeBuilt 1966 · S/N 15064307N8207GKing Paul · Mount Holly, NJBuilt 1971 · S/N 177RG0107N8207LAero Biz Development Group LLC · Washington, DCBuilt 1967 · S/N 17256407N8208GAerialscapes Inc · Hartland, WIBuilt 1971 · S/N 177RG0108N8208LMt Avi8or LLC · Sheridan, WYBuilt 1967 · S/N 17256408N8209GJames Billy J II · Comfort, TXBuilt 1971 · S/N 177RG0109N8209LAbel John R · Haslet, TXBuilt 1967 · S/N 17256409N8210MPeavy Magnus Delacy IV · Crawfordville, FLBuilt 1969 · S/N 21059210N8211GSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1971 · S/N 177RG0111N8211LWelch James J · Salisbury, NCBuilt 1967 · S/N 17256411N8212GDavis Richard M · Southport, NCBuilt 1971 · S/N 177RG0112N8212LVersaw Charles J · Center, COBuilt 1967 · S/N 17256412N8212ZJms Aviation LLC · Waynesville, OHS/N 205-0212N8213LTraining Planes LLC · Tampa, FLBuilt 1967 · S/N 17256413N8213SMcilrath Paul J · Des Moines, IABuilt 1965 · S/N 15061813N8213UJohnson Matthew K · Paducah, KYBuilt 1964 · S/N 17252113N8214FHoneycutt David · Columbus, MSBuilt 1966 · S/N 15064314N8214GKolman Michael D · Overland Park, KSBuilt 1971 · S/N 177RG0114N8214UN8214u LLC · Sheridan, ARBuilt 1964 · S/N 17252114N8215GGersten Iron · Spring Valley, CABuilt 1971 · S/N 177RG0115N8215LUmphrey Reid · Douglasville, GABuilt 1967 · S/N 17256415N8215ZRg Aviation Inc · Wilmington, DEBuilt 1962 · S/N 205-0215N8216GFarrar Edwin L · Mansfield, OHBuilt 1971 · S/N 177RG0116N8216LWoodworth Mark S · Madison, OHBuilt 1967 · S/N 17256416N8216UClinch Jerome J · Lincoln, NEBuilt 1964 · S/N 17252116N8217LSteward Kim R · Durand, ILBuilt 1967 · S/N 17256417N8218FDel Rosario Jose · Hackettstown, NJBuilt 1966 · S/N 15064318N8218LTufts Kyle J · Hampden, MEBuilt 1967 · S/N 17256418
Back to AD 72-03-03 R3