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.

N5202FUnited States Air Force (Owner) · Millington, TNBuilt 1965 · S/N 17253189N5202QRosso Matthew J · Mancos, COS/N 15073102N5203FDale County Sheriffs Office · Ozark, ALBuilt 1965 · S/N 17253192N5203QMatteis Vincent M · Lyndonville, VTBuilt 1971 · S/N 15073103N5203UHusted Robert P · Byers, COBuilt 1964 · S/N 206-0203N52044Peck John E · Everett, WABuilt 1977 · S/N 177RG1150N52046C10 Fire Aircraft Holding LLC · Sunriver, ORBuilt 1977 · S/N 177RG1152N5204FUnited States Air Force · Offutt Afb, NEBuilt 1965 · S/N 17253195N5204QWarren County Career Center · Lebanon, OHBuilt 1971 · S/N 15073104N52050Brown Thomas A · Lake Stevens, WABuilt 1977 · S/N 177RG1154N52061Ortego Kenton M · Lake Charles, LABuilt 1977 · S/N 177RG1157N5206UMudminers LLC · Wasilla, AKBuilt 1964 · S/N 206-0206N52074Harris Nancy B · Christiansburg, VABuilt 1977 · S/N 177RG1162N52076Macair Aviation LLC · Xenia, OHS/N 177RG1163N5207FUnited States Air Force Owner · Clovis, NMBuilt 1965 · S/N 17253206N52087Bodkin Donna E · Patchogue Village, NYS/N 177RG1165N5208FUnited States Air Force Owner · Beale Afb, CABuilt 1965 · S/N 17253209N5208QEmerick Benjamin F · Foster, RIBuilt 1971 · S/N 15073108N52093Helgeson Jeffrey D · Colonia, NJFirst renewal noticeBuilt 1977 · S/N 177RG1168N5209QTulsa Technology Center School District No 18 · Tulsa, OKS/N 15073109N520JCSisson Christopher S · Sarah, MSS/N 15073129N52101Defontes Kenneth W Jr · Kingsville, MDS/N 177RG1170N52120Compass Aviation Maintenance LLC · Shelby, NCBuilt 1977 · S/N 177RG1173N52132Registered aircraftS/N 177RG1174N5213QMedia Stew LLC · Carson City, NVBuilt 1971 · S/N 15073113N5214QMann Roland F · Murrayville, GABuilt 1971 · S/N 15073114N52152Schmidt Michael D · Windermere, FLBuilt 1977 · S/N 177RG1178N52154Fairfax Stephen A · Johnson City, TXBuilt 1977 · S/N 177RG1179N52156Rbl Missions LLC · Newcastle, CABuilt 1977 · S/N 177RG1180N5215FUnited States Air Force · Rio Vista, CABuilt 1965 · S/N 17253233N52167Vajtay Catherine · Englewood Cliffs, NJBuilt 1977 · S/N 177RG1184N52177Lundahl Frederick · Langley, WABuilt 1977 · S/N 177RG1186N5217QGoode Stephen C · Canton, TXS/N 15073117N5217UKelly Colby R · Anchorage, AKBuilt 1964 · S/N 206-0217N52190Vass Gal Alex D · Merrimack, NHBuilt 1977 · S/N 177RG1189N52195Cabane Marcelo J · Miami, FLS/N 177RG1191N5219QVital Aviation LLC · Monterey, CABuilt 1971 · S/N 15073119N521DMAllison James R · Middlefield, OHBuilt 1972 · S/N 17260567N521TDRaiders-Tigers Flying Club · Houston, TXBuilt 1969 · S/N 17258636N5220FUnited States Air Force · Eglin Afb, FLBuilt 1965 · S/N 17253250N5223QThealphamart LLC · Saint Petersburg, FLBuilt 1971 · S/N 15073123N5224FPfeiffer Logan A · Boonville, MOBuilt 1965 · S/N 17253263N5224QRiibe Gary J · Herman, NEBuilt 1971 · S/N 15073124N5224UNeil Anthony Foster Holdings LLC · Santa Rosa, CABuilt 1964 · S/N 206-0224N5225QMiller Kevin L · Arlington, WABuilt 1971 · S/N 15073125N5226UJohnson Stephen M · Westlake, TXBuilt 1964 · S/N 206-0226N5227QFoster Kathleen E · Long Beach, CABuilt 1971 · S/N 15073127N5228FUnited States US Air Force · Dover Afb, DEBuilt 1965 · S/N 17253277N5228UKansas Aviation Museum · Wichita, KSS/N 206-0228N5229FUnited States Air Force Owner · Clovis, NMBuilt 1965 · S/N 17253280
Back to AD 72-03-03 R3