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.

N634JWRohlmann Michael S · Saint Louis, MOS/N G-801N634MGeorge Mike J · Springfield, ILBuilt 1955 · S/N G-761N63503Criscenzo Philip A · Port Orange, FLBuilt 1982 · S/N M-2359N63549Bowyer Marcelyn W · Coppell, TXS/N 6729N6356TTangoair LLC · Birmingham, ALBuilt 1981 · S/N CE-933N63576Kronsbein Peter M A · Charlotte, NCBuilt 1982 · S/N MC-780N635APLambert Kurt P · Albuquerque, NMBuilt 1974 · S/N D-9674N635DBlue River Holdings LLC · Hugo, OKBuilt 1951 · S/N D-2957N635PPBodor Geza S · Denver, COBuilt 1967 · S/N D-8637N635SAGrellet-Aumont Pierre A · East Quogue, NYBuilt 2000 · S/N E-3336N635TJones Donald R · Sandwich, ILBuilt 1958 · S/N D-5769N635VSun Up Farm LLC · Nacogdoches, TXBuilt 1966 · S/N D-8083N6361CMaples Lee Trustee · Belle, MOBuilt 1982 · S/N D-10384N6362USundowner Holdings LLC · Mayflower, ARBuilt 1982 · S/N M-2373N6363UTf Skies LLC · Mount Pleasant, TXBuilt 1983 · S/N M-2372N63687Vsun LLC · Gilbertsville, KYBuilt 1983 · S/N M-2375N6368CDewing Matthew S · Rome, PAS/N EA285N636BAClock Adam D · Columbus, INS/N E-3482N636BERios Ralph · Chester, VABuilt 1992 · S/N E-2687N636DJunipero Aviators LLC · Redondo Beach, CAS/N D2899N636EAdams Aerial Solutions LLC · Decatur, ILBuilt 1978 · S/N E-1262N636QShaw Aviation LLC · Solomon, KSBuilt 1958 · S/N D-5711N636RALoyd Randolph · Gassville, ARBuilt 1999 · S/N E-3229N636TRegistered aircraftBuilt 1958 · S/N D-5709N636TCChamberlain David C · Keller, TXBuilt 1987 · S/N EA-463N636WTlkco LLC · Wilmington, DES/N E-3475N6370SFreeland Christopher G · Brownwood, TXS/N D-9832N63732Aeronation Aircraft & Exotics LLC · Lewes, DEBuilt 1982 · S/N M-2365N63745Johnson Robert L Jr · Cornelius, NCBuilt 1982 · S/N M-2361N6376SGray James W · Cypress, TXBuilt 1975 · S/N CE-619N637DFiske Scott H · Minnetrista, MNS/N D-2900N637PRocky Mountain Frm LLC · Kalispell, MTS/N E-3557N637QBravo Sierras LLC · Omaha, NEBuilt 1959 · S/N D-5906N6385UHilde Chadwick Q · Memphis, TNBuilt 1982 · S/N EA-290N63866Big Bend Community College · Moses Lake, WABuilt 1983 · S/N M-2374N6387UWeyermuller Scott P · Bossier City, LAS/N EA-291N6388PMurfin Drilling Co Inc · Wichita, KSBuilt 1981 · S/N E-1991N63893Hurley Matthew · Brooklyn, NYBuilt 1982 · S/N MC-787N6389UBender & Lammers LLC · Bennington, NEBuilt 1982 · S/N EA-294N638LLFire Island Flight LLC · Islip, NYS/N G-93N638PClements Scott · Royse City, TXBuilt 1981 · S/N EA-209N638TDMentair Inc · Napoleon, OHBuilt 1953 · S/N G-286N6392SAir Horse One LLC · Wauwatosa, WIBuilt 1975 · S/N TC-1918N63936Sea & Ski Nw LLC · Portland, ORBuilt 1982 · S/N E-2053N6393SRegistered aircraftBuilt 1975 · S/N CE-623N6397SIts Allgood Air LLC · Lewes, DEBuilt 1975 · S/N D-9833N639QKim Sungtae · Fort Worth, TXBuilt 1959 · S/N D-5839N63BHN63bh LLC · Auburn, ALBuilt 1977 · S/N E-1186N63BMDayton Aircraft Services Inc · Daytona Beach, FLS/N E-3410N63BRLevel Up Capital LLC · Roswell, GAS/N E-3061
Back to AD 99-05-13 R1 WD