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.

N74DPRegistered aircraftBuilt 1974 · S/N 17702150N74GTKnick Robert J · Eugene, ORBuilt 1969 · S/N 15070302N74KWWilling Kenneth Allen · Grasston, MNS/N 15063752N74MBRoland Cary T · Moscow, KSBuilt 1971 · S/N 18260789N74PPBunnell Randy D · Blakesburg, IABuilt 1968 · S/N 17700928N74SSPelletier Kevin C · Williamsport, MDBuilt 1974 · S/N 177RG0530N7502VBluewater Bay LLC · Ardmore, OKBuilt 1975 · S/N 177RG0801N7503VChuga Gregory M II · Hayes, VAFirst renewal noticeBuilt 1976 · S/N 177RG0802N7504VImage Craft LLC · Phoenix, AZBuilt 1975 · S/N 177RG0803N7505GRandall James E · Villa Park, CABuilt 1973 · S/N 15074674N7505VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 177RG0804N750JPQuasar Airlines International LLC · Moncks Corner, SCBuilt 1969 · S/N 18259684N750PHTobon Alexander J · Daphne, ALS/N 15073040N7510GBoh Air Corporation · Jenks, OKBuilt 1973 · S/N 15074676N7515GFrisbee Alice Molnar · Port Charlotte, FLBuilt 1973 · S/N 15074681N7515VRxair 2 Inc · Bella Vista, ARS/N 177RG0812N7516VOgletree Ben R Jr · Livingston, TXBuilt 1975 · S/N 177RG0813N7517GDecember 1944 LLC · Las Vegas, NVBuilt 1973 · S/N 15074683N7517VSims Albert Paul · Auburndale, FLBuilt 1975 · S/N 177RG0814N751DSHigh Exposure Inc · Wilmington, DEBuilt 1965 · S/N 15062266N7521VLeslie Warren J · Sequim, WABuilt 1976 · S/N 177RG0818N7523GTriple J Aviation LLC · Mcconnelsville, OHBuilt 1970 · S/N 17259223N7523VTwc Aviation Services LLC · Merritt Island, FLBuilt 1975 · S/N 177RG0820N7524GBrandywine Sky Ramblers LLC · West Chester, PABuilt 1970 · S/N 17259224N7526GFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1970 · S/N 17259226N7528GSale Reported · Rillito, AZSale reported, pending cancellationBuilt 1970 · S/N 17259228N7529GRibeiro Marcos F · Okeechobee, FLS/N 15074687N752DMS&M Holdings LLC · Oak Ridge, LABuilt 1962 · S/N 18254005N7530VNicolaou John G · San Ramon, CABuilt 1976 · S/N 177RG0827N7533GSiess Tye G · Hot Springs, ARS/N 15074691N7533VWilliams Jeffrey D · Sparta, NJBuilt 1976 · S/N 177RG0830N7534VCardinal Aero Group LLC · Marshall, ARBuilt 1976 · S/N 177RG0831N7535VSchneider Martin G · Milford, NES/N 177RG0832N7536VBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 177RG0833N7537VHorizon Aeronautics Inc · Columbia, SCBuilt 1976 · S/N 177RG0834N7538VLee Walker S · Searcy, ARBuilt 1976 · S/N 177RG0835N7540GKelley Aircraft LLC · Weyers Cave, VABuilt 1970 · S/N 17259240N7542GNelson Frank H · Tuscaloosa, ALBuilt 1970 · S/N 17259242N7542VCoastal Cosmetic And Implant Denistry LLC · Miramar Beach, FLBuilt 1976 · S/N 177RG0839N7543GTrue Course LLC · West Monroe, NYBuilt 1970 · S/N 17259243N7544VGavazzo Victor Grille · Saint Peters, MOBuilt 1976 · S/N 177RG0841N7547GMutter William D · Chelan, WABuilt 1970 · S/N 17259247N7548GRetro Modern Aviation LLC · Manitou Springs, COBuilt 1970 · S/N 17259248N7550G7550g LLC · Birmingham, MIBuilt 1970 · S/N 17259250N7550VGamblin Elton Berry · Vienna, VAFirst renewal noticeBuilt 1976 · S/N 177RG0847N7551GNb Airdoc LLC · Aventura, FLBuilt 1970 · S/N 17259251N7554VOlson Nicholas W · Copper Canyon, TXBuilt 1976 · S/N 177RG0850N7555GSac Air LLC · Citrus Heights, CABuilt 1970 · S/N 17259255N7555VWallen Bruce R · New Britain, CTBuilt 1976 · S/N 177RG0851N7556GWetlesen Gabriel C · Palmer, AKBuilt 1970 · S/N 17259256
Back to AD 72-03-03 R3