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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N3334TBaumann Keith A · Fairfield, ILBuilt 1967 · S/N 17700634 N3334YHarless Richard K · Battle Mountain, NVBuilt 1962 · S/N 18254334 N3335FSocorro Meraz · El Paso, TXBuilt 1966 · S/N 18257335 N3335UFogle Kenneth J · Chagrin Falls, OHBuilt 1963 · S/N 18254735 N3336SVancil Todd · Justin, TXBuilt 1969 · S/N 21059136 N3337FAerolife Aviation LLC · Knox, INBuilt 1966 · S/N 18257337 N3337SBeery Bruce M · Lakeland, FLBuilt 1969 · S/N 21059137 N3339FRegistered aircraftN-number assigned, not yet registeredS/N 17700600 N3339TBritt And Ashley Kieffer Farms · Weiner, ARS/N 17700639 N333AFChickasha Wings Inc · Chickasha, OKBuilt 1972 · S/N 17260403 N333LAWilson Matthew · Weatherford, OKBuilt 1971 · S/N 177RG0092 N333MWThird Oak Aviation LLC · Statham, GABuilt 1966 · S/N 15063324 N333QAFirth Lynn C · Auburn, NHBuilt 1968 · S/N 15069983 N333RXJourneys Aviation Inc · Boulder, COBuilt 1966 · S/N 17254308 N333SHVitez David D · Morgantown, WVBuilt 1969 · S/N 15070617 N333SPBelote David Eldon Trustee · Elbert, COBuilt 1975 · S/N 17702265 N333WGWilliams Samantha L · Kendallville, INS/N 15065465 N333YTRegistered aircraftBuilt 1968 · S/N 18258912 N3340JSteiner William Mark · Newport Beach, CABuilt 1966 · S/N 15066040 N3340RFrieze Rex · Fair Play, MOBuilt 1967 · S/N 18258640 N3340SRegistration Pending · Wilmington, DERegistration pendingBuilt 1969 · S/N 21059140 N3340UGingerich Fred D · Heron, MTBuilt 1963 · S/N 18254740 N3340YMckinney Sandra C · Williamsburg, OHBuilt 1962 · S/N 18254340 N3341FLani Lea Sky Tours LLC · Honolulu, HIBuilt 1966 · S/N 18257341 N3341RKozlenko Roman · Irvine, CABuilt 1967 · S/N 18258641 N3341TWatson Dennis R · Fort Worth, TXBuilt 1967 · S/N 17700641 N3341UKroschel Wayne Addie · Mora, MNBuilt 1963 · S/N 18254741 N3342FKaradza Bosko S · Welch, MNS/N 18257342 N3342URobert Smith Associates Inc · Albany, NYBuilt 1963 · S/N 18254742 N3343FLutes Ralph E · Shipshewana, INBuilt 1966 · S/N 18257343 N3343JAndresen Paul S · Chandler, AZS/N 15066043 N3343TMcclellan Dabney B · Centerburg, OHBuilt 1967 · S/N 17700643 N3344JSaitto Jeffrey M · Media, PAS/N 15066044 N3344RStorm Water Services Inc · Redmond, ORBuilt 1967 · S/N 18258644 N3344UPiescinski Kurt G · Fort Lauderdale, FLBuilt 1963 · S/N 18254744 N3345FBrassard Alan Gaston · Durham, NCBuilt 1966 · S/N 18257345 N3345RJennings Mamie M · Springfield, ILBuilt 1967 · S/N 18258645 N3345SSummit Foundry Systems Inc · Fort Wayne, INBuilt 1969 · S/N 21059145 N3345TJefts Donald R · Scotia, NYBuilt 1967 · S/N 17700645 N3346RGonzalez Oscar · Bedford, TXBuilt 1968 · S/N 18258646 N3346YVantrease Jerold L · Homer, AKBuilt 1962 · S/N 18254346 N3347FPrescott Aircraft & Automotive LLC · Prescott Valley, AZBuilt 1966 · S/N 18257347 N3347SArmitage Justin Marc · Hugoton, KSBuilt 1969 · S/N 21059147 N3347YMccoy Mark B · Honea Path, SCBuilt 1962 · S/N 18254347 N3348UCollins Christopher E · Bluford, ILBuilt 1963 · S/N 18254748 N3348YBlue Sky Flyers Inc · Punta Gorda, FLBuilt 1962 · S/N 18254348 N3349FMaxfield David · Greenville, SCBuilt 1966 · S/N 18257349 N33503Sueltenfuss Tyler G · Boerne, TXBuilt 1967 · S/N R-172-0242 N3350FStrait Daniel · Sierra Vista, AZBuilt 1966 · S/N 18257350 N3350SBarry Jason J · Orange, CABuilt 1969 · S/N 21059150

Back to AD 72-03-03 R3