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

N8253MHudak Organization LLC · Cedar Grove, NJBuilt 1969 · S/N 21059253N8254LDennard C Alan · Coolidge, GABuilt 1967 · S/N 17256454N8254QTogo Aviation Services LLC · Palmer, AKBuilt 1970 · S/N U2061479N8254UWolf Nathan · Wishek, NDBuilt 1964 · S/N 17252154N8255FStarks Aviation Inc · Pittsburgh, PAS/N 15064355N8255GCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1971 · S/N 177RG0155N8255LAllen Shaun M · Lake Ann, MIBuilt 1967 · S/N 17256455N8255SConz Gerald Patrick Jr · Wyandotte, MIS/N 15061855N8255ZSonoma County Fliers LLC · Petaluma, CABuilt 1963 · S/N 205-0255N8256URegistered aircraftBuilt 1964 · S/N 17252156N8256ZRapozo Martin · Tarpon Springs, FLBuilt 1964 · S/N 205-0256N8257SCrews Bryce D · Rensselaer, INBuilt 1965 · S/N 15061857N8257ZFunanich Jon J Trustee · Fairfield, CABuilt 1963 · S/N 205-0257N8259FCoker Nathan F Jr · Lynchburg, VABuilt 1966 · S/N 15064359N8259ZZulu Hay LLC · Mesa, WABuilt 1963 · S/N 205-0259N825SQuamme Eric P · Peachtree City, GAS/N 18255428N8260USteier William Charles · Inver Grove, MNBuilt 1964 · S/N 17252160N8261GBaer Charles · Terre Haute, INBuilt 1971 · S/N 177RG0161N8261ZWardlay Farms And Ranches · Grandview, TXBuilt 1963 · S/N 2050261N8262LMclean Corey J · Houston, TXBuilt 1967 · S/N 17256462N8262MThrasher Dennis L · Tucson, AZBuilt 1970 · S/N 21059262N8264LMorelock Colleen P · Beavercreek, OHBuilt 1967 · S/N 17256464N8265GYencarelli Mark S · Riverview, FLS/N 177RG0165N8265LUz Stephanie S · Arlington, VABuilt 1967 · S/N 17256465N8265UHickey Kenneth E · Crossville, TNS/N 17252165N8266FOnemanconcrete LLC · Thaxton, VABuilt 1966 · S/N 15064366N8266GBode Todd D · Brush Prairie, WABuilt 1971 · S/N 177RG0166N8266MCenturion Aviation LLC · Groveland, FLBuilt 1970 · S/N 21059266N8266SRankin Gregory E · Wetumpka, ALBuilt 1965 · S/N 15061866N8267FPokorny John · Woodstock Valley, CTBuilt 1966 · S/N 15064367N8267LInverted Aviation LLC · Atascadero, CABuilt 1967 · S/N 17256467N8268FBudd Jim · Rushville, NEBuilt 1966 · S/N 15064368N8268ZButler Aviation Group LLC · Tonopah, AZBuilt 1963 · S/N 205-0268N8269LOneal Gary L · Springdale, ARBuilt 1967 · S/N 17256469N826KJHlm Aircraft LLC · Marion, MSBuilt 1968 · S/N 18259041N826WSaucedo Arnoldo · Midland, TXS/N 18256526N826XHHoleman Darren C · New Town, NDS/N 150-74756N8270SN83993 LLC · Cherry Hill, NJExpired dealerBuilt 1965 · S/N 15061870N8271GCantrell Dean P · Greenwood, INBuilt 1971 · S/N 177RG0171N8271LLanni David L · Fairbanks, AKBuilt 1967 · S/N 17256471N8271SKontz Gary Lee · Canby, MNBuilt 1965 · S/N 15061871N8272LMarfull Eric · Roseville, CAS/N 17256472N8272SVierheller Glenn Eric · Seville, OHBuilt 1965 · S/N 15061872N8272UCraig Harry L II · Buckhannon, WVBuilt 1964 · S/N 17252172N8273FAir Charterz LLC · Columbus, OHS/N 15064373N8273UWings Of Grace Ministries Inc · Melbourne, FLBuilt 1964 · S/N 17252173N8273ZGssl Inc DBA · Tillamook, ORBuilt 1963 · S/N 2050273N8274FMcclain Daniel S · Enon Valley, PAS/N 15064374N8274GMorris Robert B · Star Valley, AZBuilt 1971 · S/N 177RG0174N8275FStanford Michael · Victoria, TXBuilt 1966 · S/N 15064375
Back to AD 72-03-03 R3