Skip to content

AD 99-05-13 R1 WD

Registered aircraft · 13,518

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

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:99-05-13-R1-WD') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD') ORDER BY n_number

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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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.

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:99-05-13-R1-WD')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N890RChitwood Thomas · Hartwell, GABuilt 1960 · S/N D-6365 N890WBelcher Timothy A · Liberty, KSBuilt 1964 · S/N D-7563 N8910AAllison Loyd M · Molt, MTBuilt 1950 · S/N D-2608 N8911ABeverage Jamie L · Crescent, OKBuilt 1950 · S/N D-2662 N8911UBerry John O · Dexter, NMFirst renewal noticeBuilt 1965 · S/N TC-947 N8911XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1998 · S/N E-3166 N8917ARosenkranz Rashell Denning · Ellensburg, WABuilt 1950 · S/N D-2617 N8917MAero Flite Del Inc · Felton, DEBuilt 1964 · S/N D-7322 N8917UBashaw Trenton C · Newport Beach, CABuilt 1965 · S/N D-7910 N891JHBecker Lawrence D · Anacortes, WABuilt 1955 · S/N D-4101 N8921ULucy Donald E III · Newbury Park, CABuilt 1965 · S/N D-7911 N8922UN8922u LLC · Twin Falls, IDS/N D-7913 N8923UCarolina Insulation & Foam Inc · Asheboro, NCBuilt 1965 · S/N D-7917 N8924AIrion Thomas J · Livermore, CABuilt 1950 · S/N D-2624 N8924MTre Aviation Corp · Wilmington, DEBuilt 1964 · S/N D-7337 N8924UPan American Handling LLC · Mooresville, NCBuilt 1965 · S/N TC-949 N8925ATaylor Ernest N Jr · Doral, FLBuilt 1950 · S/N D-2625 N8926AEllington William E Jr · Houston, TXS/N D-2626 N8927ANatale Julian K · Wakefield, RIBuilt 1950 · S/N D-2627 N8928MKeyt Jeffrey D · New Providence, NJBuilt 1963 · S/N TD-555 N892JHMaitland Property Management LLC · Plano, TXBuilt 2000 · S/N E-3323 N892MCMcn Aviation LLC · San Antonio, TXBuilt 1975 · S/N P-353 N892PMcburney: Associates LLC · Lakeway, TXBuilt 1976 · S/N TC1947 N892WWWasserburger John C · Collierville, TNBuilt 1992 · S/N CE-1694 N8930ACusick Christopher J · La Jolla, CABuilt 1951 · S/N D-2684 N8930MCuratola Bruce J · League City, TXS/N M-318 N8932US35 Aviation LLC · Lakeland, FLBuilt 1965 · S/N D-7921 N8933Walthers John P · Mequon, WIBuilt 1989 · S/N CE-1384 N8934MLance Toland Ltd · Griffin, GABuilt 1964 · S/N BA-664 N8939ABoyd Craig S · Richardson, TXBuilt 1951 · S/N D-2693 N8939MCyrier John · Lockhart, TXBuilt 1964 · S/N TC-551 N8939USiegfried Robert W II · Downers Grove, ILBuilt 1965 · S/N D-7924 N8942UConner Ernest A III · Dallas, TXBuilt 1965 · S/N D-7933 N8944APetersen Amos I · Iowa City, IAS/N D-2698 N8944DFerguson Parker W · Norman, OKBuilt 1966 · S/N D-8285 N8944MEngland Neil Dean Jr Trustee · Watsonville, CABuilt 1965 · S/N D-7940 N8945ADodson International Parts Inc · Rantoul, KSBuilt 1951 · S/N D-2699 N8945UPoeppelman Philip W · Versailles, OHBuilt 1965 · S/N D-7923 N8946UEilers John D · Royal City, WABuilt 1965 · S/N D-7928 N8948UClarke Cheryl A · Oakley, CABuilt 1965 · S/N D-7945 N8950ABeechcraft C-35 Lc · Cameron Park, CABuilt 1951 · S/N D-2704 N8950MPacific Flight Academy LLC · Honolulu, HIBuilt 1963 · S/N TD-558 N8950UManley Steven T · Dallas, TXBuilt 1965 · S/N TD-641 N8951MZimmerman Bruce M · Crittenden, KYBuilt 1964 · S/N D-7338 N8958ADrinkard Robert L · Moro, ORBuilt 1951 · S/N D-2712 N8960MSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1963 · S/N TC-559 N8961AJenkins James L DBA · Lake Stevens, WABuilt 1957 · S/N D-2715 N8963ANicola Gary L · Lansing, MIBuilt 1951 · S/N D-2717 N8964ARice Johnny D · Rosharon, TXBuilt 1951 · S/N D-2718 N8966CStiles David · Saint Petersburg, FLS/N D-3231

Back to AD 99-05-13 R1 WD