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

N9757LGasper Joseph · New Port Richey, FLBuilt 1972 · S/N M-1378N9757RVan Noy Stephen E · Alliance, NEBuilt 1960 · S/N D-6286N9757YVectair Aviation LLC · League City, TXBuilt 1963 · S/N D-7147N9758RTurner Richard Walser Trustee · Rocky Gap, VABuilt 1960 · S/N D-6304N9759RSanders Kenneth E · Millsap, TXBuilt 1959 · S/N D-6238N975QA2b Adventures Inc · Kennesaw, GABuilt 1961 · S/N D-6840N975QCYoung Billy G · Livingston, TXBuilt 1970 · S/N D-9114N975RMclane Norman B · Mesa, AZBuilt 1979 · S/N D-10276N9761YAllen Karen J · Walnut Grove, CAS/N D-7146N9763RSpencer Eric M · Glenrock, WYFirst renewal noticeBuilt 1960 · S/N D-6305N9763YSouth Delta Aviation Inc · West Helena, ARBuilt 1963 · S/N D-7148N9764RSchaffert Warren E · Trenton, NES/N D-6247N9765LMartone Aviation LLC · Ocala, FLBuilt 1972 · S/N M-1383N9765RHathorn Luther G · Corsicana, TXBuilt 1959 · S/N D-6243N9765YHutchinson Kevin J · Poplar Grove, ILBuilt 1963 · S/N D-7151N9766YGleo LLC · Downers Grove, ILBuilt 1963 · S/N D-7152N9767RRowell Jerome F · Winchester, VABuilt 1959 · S/N D-6254N9768RGeorge Raymond R · Shadow Hills, CABuilt 1959 · S/N D-6244N976BEAero Sphere Inc · Mcclellan, CABuilt 1979 · S/N ME-252N976CAFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1979 · S/N ME228N976DSFisher Samuel J · Nahant, MABuilt 1976 · S/N D-9931N976MKLyman John W · Orrs Island, MEBuilt 1976 · S/N TC-1973N9770RSmith Francis K · Saint Inigoes, MDBuilt 1960 · S/N D-6285N9771LLarson Steven E · Columbus, NEBuilt 1972 · S/N M-1402N9772RAterianus Jacques · Suamico, WIS/N D-6264N9773YAirhart Michael · Justin, TXBuilt 1963 · S/N D-7155N9774YSpenle Robert L · New Auburn, WIBuilt 1963 · S/N D-7159N9775LLassiter Jason T DBA · Ephrata, PABuilt 1972 · S/N M-1391N9775YHamilton Christopher S · Bowling Green, KYBuilt 1963 · S/N D-7156N9777LEarl W Morrow Cpa Pe · Williamson, GAFirst renewal noticeBuilt 1972 · S/N M-1392N9777RSingleton Shawn P · Nipomo, CABuilt 1959 · S/N D-6268N9777YNunneley Ian · Port Saint Joe, FLBuilt 1963 · S/N D-7160N9779RRhodes Orval D · Aztec, NMBuilt 1960 · S/N D-6284N9779YNovosielski John · Richfield, OHBuilt 1963 · S/N TC-440N977AGFlying T Farms LLC · Callao, MOBuilt 1966 · S/N TE-116N977CTPrecision Aerial Photography LLC · Oceanside, CABuilt 1993 · S/N E-2791N977JLLabrie James R · Southampton, MABuilt 1979 · S/N CE-872N977KMBusse Steve T · Cincinnati, OHFirst renewal noticeBuilt 1964 · S/N D-7366N977PAGlobal Aviation Corp · Farmingdale, NYBuilt 1979 · S/N ME-195N977QVanderstel Richard J · Grand Haven, MIBuilt 1961 · S/N D-6923N977TTechnical Systems Management Corp · Siler City, NCBuilt 1960 · S/N DH-264N977VCross Richard Laurence · Terre Haute, INBuilt 1966 · S/N TE-111N9780LPatterson John M · Elkton, FLBuilt 1972 · S/N MC-113N9782LConnolly David · Austin, TXBuilt 1972 · S/N M-1393N9783LBeck Joseph P III · Pollock, LABuilt 1972 · S/N M-1394N9783RMoore Michael C · Brooklyn, MIBuilt 1960 · S/N D-6488N9783YOneal Hollis · Deridder, LABuilt 1963 · S/N TC-441N9785RShaul Kurt · Kelseyville, CABuilt 1960 · S/N D-6294N9786RLaguna Henry · Glendale, CAS/N D-6299N9787RThorny Oak Ranch LLC · Missouri City, TXBuilt 1960 · S/N D-6303
Back to AD 99-05-13 R1 WD