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.

N727LBMcnamee John B · Sugar Land, TXBuilt 1974 · S/N 177RG0626N727LCBurmaster Christopher R · Murfreesboro, TNBuilt 1966 · S/N 17254788N727LGYouth & Aviation Inc · Thiensville, WIBuilt 1968 · S/N 17256938N727LHHale John A · Ennis, MTBuilt 1965 · S/N P206-0085N727SFRenko Steven E · Elmira, NYBuilt 1968 · S/N 17256791N7282GDurley Randal W · Talladega, ALFirst renewal noticeBuilt 1973 · S/N 15074634N7282SDavis Patrick I · Acampo, CABuilt 1967 · S/N 15067982N7283GPetersen Conrad H · Kenmare, NDBuilt 1973 · S/N 15074635N7283SMiller Bambi · Lee, NHS/N 15067983N7284GFisher Global LLC · Faulkner, ARBuilt 1970 · S/N 17258984N7285SHenry Mark A · Dickinson, TXBuilt 1967 · S/N 15067985N7286GRegistered aircraftBuilt 1973 · S/N 15074636N7286QLacombe Bryan K · Rockwall, TXBuilt 1972 · S/N 17260586N7286SMaychezak Lana R · Sentinel Butte, NDBuilt 1967 · S/N 15067986N7287GTen Mile Ranch Inc · Vale, ORBuilt 1970 · S/N 17258987N7288QAerosmith Aviation LLC · Marietta, GAFirst renewal noticeS/N 17260588N7289SHancock Deborah M · Hayes, VABuilt 1967 · S/N 15067989N728LCHeath Richard · Raymondville, TXBuilt 1974 · S/N 15075773N7291GKuntz Jeffrey A · Covington, OHBuilt 1970 · S/N 17258991N7292GMarquette County Flying Club · Marquette, MIBuilt 1970 · S/N 17258992N7292QDevereaux Bruce O · Pewamo, MIBuilt 1972 · S/N 17260592N7293SGraham John T · Phoenix, AZBuilt 1967 · S/N 15067993N7295GHessel Block Co Inc · Hessel, MIS/N 17258995N7295QKangas Lisa M · Fairbanks, AKS/N 17260595N7295SSpeedbird Ventures LLC · Driftwood, TXS/N 15067995N7296GWind Walker LLC · Tucson, AZS/N 17258996N7296QRich Aviation Services LLC · Fort Worth, TXBuilt 1972 · S/N 17260596N7297GBraun Ralph H · Moreno Valley, CAS/N 15074638N7297SBukkila Joan E · Savage, MNBuilt 1967 · S/N 15067997N7299QStout Oscar M · Brookshire, TXS/N 17260599N72BLSkrow Works Inc · West Monroe, LAS/N 17257795N72CPGrant Henry R H · Ocracoke, NCBuilt 1973 · S/N 15075051N72CXCorsair Engine Technologies · Colorado Springs, COBuilt 1969 · S/N 17258725N72PFKuck Russell W · Aguila, AZBuilt 1965 · S/N 17253530N7301GFreeport Flyers Inc · Freeport, ILBuilt 1970 · S/N 17259001N7302GSmith Neil W · Rincon, GABuilt 1970 · S/N 17259002N7303GGolden Greg J · Thurman, IABuilt 1973 · S/N 15074640N7304GChapman David C · Summersville, WVBuilt 1970 · S/N 17259004N7308GOrlandi Properties LLC · Blairstown, NJBuilt 1970 · S/N 17259008N7310GMccall Freddie W Jr · East Brewton, ALBuilt 1970 · S/N 17259010N7312GKlitzke Lucanus E · La Plata, NMBuilt 1973 · S/N 15074644N7313GBend-Over Hill Aviation LLC · Dover, DEBuilt 1973 · S/N 15074645N7314GKittle Aviation LLC · Wichita, KSBuilt 1970 · S/N 17259014N7316GCox Capital LLC · Rushville, MOS/N 17259016N7317GSettles Lauren E · Owensboro, KYBuilt 1970 · S/N 17259017N7318GMay Curtis · Joplin, MTBuilt 1970 · S/N 17259018N7319GPiguzov Yevgeniy · Hillsborough, NJBuilt 1970 · S/N 17259019N731AALandis Lloyd B · Ardmore, OKBuilt 1970 · S/N 182-60331N731RLTrevor Liou · Brush Prairie, WABuilt 1965 · S/N 18256519N731TXRegistration Pending · Harrah, OKRegistration pendingBuilt 1973 · S/N 177RG0337
Back to AD 72-03-03 R3