OpenAirDocs.org
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.

N50865Smith Leslie A · Waresboro, GAFirst renewal noticeBuilt 1968 · S/N 15069606N50868Krekacs Gabor · La Crescenta, CABuilt 1968 · S/N 15069608N50871Saint Joseph Of Cupertino Shenandoah Flying Assoc · Winchester, VABuilt 1968 · S/N 15069610N50874Priddle Linda Ann · Carlsborg, WABuilt 1968 · S/N 15069613N50875Krs Aerial Inc · Plain City, OHS/N 15069614N50876Parker David A · Sacramento, CAS/N 15069615N5087BSchwebach Victoria L · Coronado, CAS/N 18255988N50887Stanton Sport Aviation Inc · Stanton, MNBuilt 1968 · S/N 15069620N5088USinnott Simonis Lyle · Girdwood, AKBuilt 1963 · S/N 206-0088N50891Peterson Andrew B · Louisville, KYBuilt 1968 · S/N 15069623N50896Bankhead David B · Montrose, WVBuilt 1968 · S/N 15069625N50898Costa Air Service LLC · Painted Post, NYS/N 15069626N50904Karges Kip · Tuscola, TXBuilt 1968 · S/N 15069631N50909Keystone Aviation Group LLC · Paxinos, PABuilt 1968 · S/N 15069634N5090UVolatile Aero Ventures LLC · Boulder City, NVS/N 206-0090N50911Graves Robert E · Danville, INBuilt 1968 · S/N 15069636N50914Calhoun John R · Baton Rouge, LABuilt 1968 · S/N 15069638N50915Donato Robert J · East Berlin, PABuilt 1968 · S/N 15069639N50920Campbell James R · Temple City, CABuilt 1968 · S/N 15069643N50921Hernandez Jesus C · Elberton, GABuilt 1968 · S/N 15069644N50936Qualitair LLC Trustee · MichelstadtS/N 15069656N50948Salomonsson Mats E · Hayward, CABuilt 1968 · S/N 15069668N50957Anklam Eugene E · Claremore, OKS/N 15069673N50960Ortiz Tech LLC · Doral, FLBuilt 1968 · S/N 15069675N50961Flight Skills LLC · Raleigh, NCBuilt 1977 · S/N 177RG1136N50984Roberts Wayne A Jr · Juneau, AKBuilt 1968 · S/N 15069687N50987Berg James O · Dunseith, NDBuilt 1968 · S/N 15069690N50990Fielden Virgil A · Fairfield, TXBuilt 1968 · S/N 15069693N50992Flom Tyler M · Evans, GABuilt 1968 · S/N 15069695N50994Plane Junkies LLC · Dover, DES/N 15069696N50996Burke John E · Spring, TXBuilt 1968 · S/N 15069698N509BWAnderson Richard D Jr · Remus, MIBuilt 1962 · S/N 18253974N50CGDixon Jack · Casa Grande, AZS/N 18260110N50JXDls Holdings Inc · Arlington, TXBuilt 1973 · S/N 15074642N50PKGuinn Dennis R · Nevada, TXBuilt 1968 · S/N 17701311N50PTJackson Michael W · Bedford, TXBuilt 1968 · S/N 15069220N50RCBuric Ivan Nmn · Panama City, FLBuilt 1974 · S/N 177-02087N50TLSmith Lynn D · Roosevelt, UTBuilt 1970 · S/N A1500203N50XFHdw Florida Helicopters Inc · Pompano Beach, FLS/N 15074345N51000Jet-I Aviation LLC · Palm City, FLS/N 15069700N51009Bowers Shane A · Bixby, OKBuilt 1968 · S/N 15069706N5100FAir & Space Education Instittute Inc · Pine Knot, KYBuilt 1964 · S/N 17251947N51029Cywan Alex M · Sherman Oaks, CABuilt 1968 · S/N 15069716N51040Pruitt Benny G · Reidsville, NCBuilt 1968 · S/N 15069721N51046Weeks Thomas W · Ypsilanti, MIBuilt 1968 · S/N 15069726N51047Huls Timothy J · Stevensville, MTBuilt 1968 · S/N 15069727N51048Heermance Timothy Jr · West Palm Beach, FLBuilt 1968 · S/N 15069728N51052Smithard Austin · Peachtree, GAS/N 15069730N51059Donadio Gerard J · Ronkonkoma, NYS/N 15069736N51060Elmore Eric T · Colorado Springs, COS/N 15069737
Back to AD 72-03-03 R3