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.

N484DAlman Inc · Fort Lauderdale, FLBuilt 1992 · S/N CE-1699N4850JCardamone Rayner Mark Gibson · Manistique, MIBuilt 1966 · S/N D-8345N4852JStoffel Christopher David · Colorado Springs, COS/N D-8349N4853JNaca 130 LLC · Cameron Park, CABuilt 1966 · S/N D-8350N4856JN4856j LLC · Boulder, COBuilt 1967 · S/N D-8536N485HPHigh Performance Aircraft LLC · El Cajon, CABuilt 1989 · S/N CE-1328N4862JWicker Gregory B · Irmo, SCBuilt 1966 · S/N TC-1024N4867JNational Aero Services LLC · Helena, MTBuilt 1966 · S/N TE-276N4868JFoster Milton F · Dawson, GABuilt 1966 · S/N TE-277N4869JDls Aviation LLC · Gilmer, TXBuilt 1966 · S/N TE-281N486ACSoaring Soul LLC · Brainerd, MNBuilt 1974 · S/N TC-1662N486BSale Reported · Nixa, MOSale reportedS/N D-1506N486HPSlipstream Aviation LLC · La Crosse, WIBuilt 1989 · S/N CE-1342N4871JGray Robert R · Granbury, TXBuilt 1966 · S/N D-8356N487CCJgm Aviation LLC · Spring, TXBuilt 1943 · S/N 4837N487HPAlpha Niner Niner LLC · Winter Garden, FLBuilt 1989 · S/N CE-1333N488Woodward Jeffery Scott · San Angelo, TXBuilt 1955 · S/N D-4243N4889JRegistered aircraftBuilt 1967 · S/N D-8424N488DPRodarte Lionel · Downey, CABuilt 1974 · S/N E-522N488FDLittleton Darrell D · Atlanta, TXBuilt 1968 · S/N D-8700N488HPHigh Performance Aircraft LLC · El Cajon, CABuilt 1989 · S/N CE-1338N488JFMentoraire LLC · Lake Forest, CABuilt 1953 · S/N G-298N488JMThorup Scott I · Abilene, TXBuilt 1984 · S/N E-2140N488TWilliams Alvis Leon · Heavener, OKS/N D-6726N4894JCapri Blue Aviation LLC · Norcross, GABuilt 1967 · S/N D-8430N4896JMyshatyn Michael · Eaton, COBuilt 1967 · S/N D-8435N489EJerrolds Skye S · Knoxville, TNBuilt 1948 · S/N D-1509N489HPHigh Performance Aircraft LLC · El Cajon, CABuilt 1989 · S/N CE-1343N489MHendrix Danny J · Aledo, TXBuilt 1960 · S/N D-6505N48ABBailey Robert L · Dover, DEBuilt 1954 · S/N D-3769N48BWBroadmoor Bed And Breakfast LLC · Colorado Springs, COBuilt 1975 · S/N CE-582N48CBWells Bryan G · Stephenville, TXBuilt 1950 · S/N D-2203N48CMR Stephen Smith Inc · Wichita, KSS/N TE-985N48GCRoyal Air Inc · Shreveport, LABuilt 1970 · S/N P167N48JHFlying O Consulting LLC · Hammon, OKBuilt 1971 · S/N E-297N48KUWildcat Aviation LLC · Wilmington, DEBuilt 1979 · S/N D-10303N48LFKraxberger Scotty L · Salida, COBuilt 1964 · S/N D-7489N48MGarrison William E · Nickerson, KSBuilt 1996 · S/N BA-155N48MHSeventh North Hangar LLC · Bolton, MAS/N D-9184N48RKKinnischtzke Lyle V · Mandan, NDBuilt 1989 · S/N CE-1396N48RSColin A Oerton · Miami Beach, FLBuilt 1966 · S/N D-8250N48TIndian Springs Cattle Co Ltd · Wilmington, DEBuilt 2000 · S/N E-3320N48TZVisibility Unlimited LLC · Carbon, INS/N E-1804N48WCBaron Acquisition LLC · Wayne, PABuilt 1981 · S/N TJ-350N48WWSupercub Aviation LLC · College Station, TXBuilt 1976 · S/N E-940N4908Ballew Jackie C · Rogersville, MOBuilt 1962 · S/N D-7014N490HPBreit Sky Aviation LLC · Sioux Falls, SDBuilt 1989 · S/N CE-1335N490MLegacy Ofs Construction LLC · Stillwater, OKBuilt 1983 · S/N EA-390N490PAnthony Ballone · Tulsa, OKRevoked, canceledBuilt 1948 · S/N D-1510N490TBowen Edmund L · Laguna Beach, CAS/N D-6644
Back to AD 99-05-13 R1 WD