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.

N91835Page Farms Inc · Natchitoches, LABuilt 1969 · S/N 18259928N91844Brandt Kurtis L · Susanville, CABuilt 1969 · S/N 18259929N91845Broderick Donald S · S San Fran, CABuilt 1969 · S/N 18259930N91846Bas Part Sales LLC · Greeley, COBuilt 1969 · S/N 18259931N91848Mike Alpha Mike LLC · Lafayette, LABuilt 1967 · S/N 15067491N9184KRuggiero George J · Whitney Point, NYS/N U206-0425N91852Kennon Wesley F · Doniphan, MOS/N 18259934N91860Ransom Bob · Pasco, WABuilt 1969 · S/N 18259937N91866Weldon Jeffrey A · Anacortes, WABuilt 1969 · S/N 18259939N91868V12 Enterprises LLC · Niceville, FLBuilt 1969 · S/N 18259940N9188KGallion David B · Michigan City, INBuilt 1968 · S/N 18259164N9188MSturgis Jason A DBA · Talkeetna, AKBuilt 1970 · S/N U20601588N918CTBlinn Gilbert Trustee · Eastsound, WABuilt 1968 · S/N 18259387N91900Lewis Jeery K · Cocolalla, IDBuilt 1969 · S/N 18259942N91907Skierka Christopher · Browning, MTBuilt 1969 · S/N 18259947N91912Champagne Estates Inc · Wilmington, DEBuilt 1969 · S/N 18259949N91916Hanson Larry G · Seattle, WABuilt 1969 · S/N 18259950N91917Fairchild Chad E · Logandale, NVBuilt 1969 · S/N 18259951N9191GFischer Gary H · Savannah, GAS/N 18260731N91926Pacific Flying Association LLC · Aurora, ORBuilt 1969 · S/N 18259955N91928Moseley Michael S · Chelsea, ALBuilt 1969 · S/N 18259957N9192GWg Aero LLC · Shreveport, LABuilt 1971 · S/N 18260732N9192MHandelin Gary W · Carson City, NVBuilt 1970 · S/N U20601592N91937Munsell Kenneth L · Stuart, FLBuilt 1969 · S/N 18259961N91941West Debra C · Dillon, COBuilt 1969 · S/N 18259963N91942Marvelous Margies Flying Club LLC · Helper, UTS/N 18259964N91950Bruno Cosimo Gino · Spokane, WABuilt 1969 · S/N 18259966N91958Greenwood Richard S · Duncan, OKBuilt 1969 · S/N 18259967N91963Justpullin Inc · Wilmington, DEBuilt 1969 · S/N 18259970N9196GJohnson Judith A · Sedro Woolley, WABuilt 1971 · S/N 18260736N91976Tucker Bobby G · El Dorado, ARBuilt 1969 · S/N 18259975N91978Dvorak Ross E · Highland, CABuilt 1969 · S/N 18259976N9197GWheeler Dealer LLC · Wilmington, DEBuilt 1971 · S/N 18260737N91987Sander William D · Eaton, COBuilt 1969 · S/N 18259982N9198GDuckflyway LLC · Herscher, ILS/N 18260738N91999Gembala Randall L · Kalispell, MTBuilt 1969 · S/N 18259990N919DCDelaware Corp · Topping, VABuilt 1976 · S/N 177RG1055N919RRodriguez Daniel L · West Linn, ORS/N 21059032N91RBlack Pilots Of America Detroit Chapter · Detroit, MIS/N 15067793N92000Clift Robert E · Anchorage, AKBuilt 1969 · S/N 18259991N92009Will Dennis L · Clyde, MIBuilt 1969 · S/N 18259997N9200GNoya Charles J · Albuquerque, NMBuilt 1971 · S/N 18260740N9200XCochreham Bryce O · Seibert, COBuilt 1962 · S/N 18253600N92013Burns Dale E · Kamiah, IDBuilt 1969 · S/N 18259999N92016Campbell Kevin T · Gretna, NEFirst renewal noticeBuilt 1969 · S/N 18260002N92018Mercenary Medical LLC · St George, UTBuilt 1969 · S/N 18260004N92020Domaille Dennis C · Mammoth Lakes, CABuilt 1969 · S/N 18260006N92021Pisiak Sonny S · Queen Creek, AZS/N 18260007N9202XNohrenberg Larry R · Jamestown, NDBuilt 1962 · S/N 18253602N92039Newwing LLC · Freeland, WABuilt 1969 · S/N 18260014
Back to AD 72-03-03 R3