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.

N92597Morgan Ent LLC · Richland, IABuilt 1970 · S/N 18260276N925JKLonghorn Listings Inc · San Antonio, TXS/N U206-0969N925RRHahn John K · Evansville, INBuilt 1969 · S/N 18260190N92600Windh Steven R · Reedley, CABuilt 1970 · S/N 18260278N9260GPeyton Julia H · Santa Barbara, CAFirst renewal noticeBuilt 1971 · S/N 18260800N9260XColvin Buster · Big Cabin, OKBuilt 1961 · S/N 18253660N92616Holby W Barrett Jr · Warren, RIBuilt 1970 · S/N 18260284N92638Van Raden Chris · Portland, ORBuilt 1970 · S/N 18260291N92639Pryor Aviation LLC · Hutchinson, KSS/N 18260292N9263GN9263g LLC · Marshall, MOS/N 18260803N9263XMieloszyk Nicholas A · Elko, NVS/N 18253663N92644Atkins Doug · Murfreesboro, TNBuilt 1970 · S/N 18260293N92648Bender Phillip H · Bloomingdale, OHBuilt 1970 · S/N 18260295N9265XWestern Pilot Service Inc · Phoenix, AZBuilt 1961 · S/N 18253665N92665Rupke Curtis · Washington, NCBuilt 1970 · S/N 18260302N9266GCole Mark A · Forest City, NCBuilt 1971 · S/N 18260806N9266XWeichert Robert S · Parker, COS/N 18253666N9266ZR M B G Inc · Winnsboro, LABuilt 1967 · S/N R1720212N92675Miller Saima A · Kodiak, AKBuilt 1970 · S/N 18260305N92677Burriss James E · Piedmont, SCBuilt 1970 · S/N 18260307N9267GWaypoint Financial Services LLC · Raiford, FLBuilt 1971 · S/N 18260807N92680E & T Research And Development LLC · Sanford, NCBuilt 1970 · S/N 18260308N92690Nelson Richard B · San Mateo, FLBuilt 1970 · S/N 18260312N92691Registration Pending · Lebanon, TNRegistration pendingBuilt 1970 · S/N 18260313N926MNPtw Consulting LLC · Atlanta, GABuilt 1971 · S/N 17260325N92707Farquharson John L · Goldsby, OKS/N 18260319N9270GFrye Warren S · Galax, VABuilt 1971 · S/N 18260810N9270XCastle Rock Services LLC · Helena, MTBuilt 1961 · S/N 18253670N92712Pfister Michael J · Roanoke, ILBuilt 1970 · S/N 18260321N92725Tucker Kyler T · Cypress, TXBuilt 1970 · S/N 18260329N92726Gray Stanley Paul Jr · Temecula, CABuilt 1970 · S/N 18260330N9272GSena James H · Edmond, OKBuilt 1971 · S/N 18260812N92739Mcmillin Michael C · Des Moines, IABuilt 1970 · S/N 18260335N9273GPlisko Aviation LLC · Beaufort, NCBuilt 1971 · S/N 18260813N92746Hansen Barbara · Armstrong, IAS/N 18260336N9274XGawlik Leslie W · Reisterstown, MDBuilt 1961 · S/N 18253674N9274ZIsham Shane A · Wichita, KSS/N R172-0219N92750Rauton Ken · Temecula, CABuilt 1970 · S/N 18260339N92757Omegna Suzanne M · Spanaway, WABuilt 1970 · S/N 18260342N92758Wayne Alan A · Flowery Branch, GABuilt 1970 · S/N 18260343N92764Bernstein Jeffrey J · Swanton, MDBuilt 1970 · S/N 18260345N92776Rivera Rivera Jose Manuel Trustee · Royal Palm Beach, FLBuilt 1970 · S/N 18260349N92787Quade James C · Duluth, MNBuilt 1970 · S/N 18260356N92788Bas Part Sales LLC · Greeley, COS/N 18260357N9279XKhoury Alain W · Wills Point, TXBuilt 1961 · S/N 18253679N927NBlue Sky Business Services Inc · Gardiner, NYBuilt 1970 · S/N 18260320N9280MRiley Dean A · Friday Harbor, WABuilt 1972 · S/N 17260490N92814Kimbrell Tod L Jr · Itasca, TXBuilt 1970 · S/N 18260371N92815Halver Todd L Trustee · Advance, NCBuilt 1970 · S/N 18260372N92816Van Cleve G Steven · Windermere, FLBuilt 1970 · S/N 18260373
Back to AD 72-03-03 R3