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.

N5437UBatdorf Richard E · Naples, FLBuilt 1967 · S/N TE-406N5438DGanter Lewis C · Sherman, TXBuilt 1957 · S/N D-5016N543RCBarone Nicholas D · Lincoln, RIBuilt 1987 · S/N E-2384N543TZulu LLC · Hattiesburg, MSBuilt 1961 · S/N D-6737N543VWich Robert · Norfolk, VABuilt 1995 · S/N EA-581N5442UMorisseau Walner · Tampa, FLBuilt 1967 · S/N D-8516N5444UBooze Gregory Trustee · Punta Gorda, FLBuilt 1967 · S/N D-8518N5445DLabtech Expert LLC · Waycross, GABuilt 1957 · S/N D-4924N5447DN5447d LLC · Seminole, OKS/N D-5001N5447NLady Mcgregor Aviation LLC · Santa Teresa, NMBuilt 1943 · S/N 4875N5448UMathews Roy · Bay Shore, NYBuilt 1967 · S/N TG-14N5449DDavis Roger T · Lakeland, FLBuilt 1957 · S/N D-4935N544BSAerospace Trust Management LLC Trustee · Wilmington, DES/N EA-246N544STGordon Jonathan · Bronxville, NYBuilt 1969 · S/N CJ-22N544VIngle Maurice O III · Claremore, OKBuilt 1965 · S/N D-7904N5450DAirline Holding Co Inc · Wilmington, DEBuilt 1957 · S/N D-4978N5450UStay Air Borne LLC · Wilmington, DEBuilt 1967 · S/N D-8529N5451DRestoration Ministry Inc · Allentown, PAS/N D-5252N5452WTechnical Education Services Inc · Virginia Beach, VABuilt 1965 · S/N LC-191N54532Qualitair LLC Trustee · MichelstadtS/N TD-541N5454DLelouis Michael P · Sacramento, CABuilt 1957 · S/N D-4942N5455UArgosy Venture Corporation · Pagosa Springs, COBuilt 1967 · S/N TG-22N545AEelkema Peter C · Mckenzie Bridge, ORFirst renewal noticeBuilt 1949 · S/N D-2197N545GMInternational Air Services Inc Trustee · Carson City, NVBuilt 1972 · S/N D-9318N545HBeechcraft Heritage Museum Inc · Tullahoma, TNS/N D-4982N545LKKernisan Louis Philippe · Doral, FLBuilt 2000 · S/N E-3348N545TYoung Trinity D · Mena, ARS/N D-6599N545VSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N D-6321N5461Lb Flying Aces LLC · Wilmington, DEBuilt 1991 · S/N E-2621N5461DCenter For Endodontics Inc · Fresno, CABuilt 1957 · S/N D-4966N5462XThomas Jackson Smitih · Baton Rouge, LABuilt 1977 · S/N E-1105N5463DBlanco Austin · Newcastle, CABuilt 1957 · S/N D-4959N54654American Flight Museum · Topeka, KSS/N BG-247N5465DPatten Sarah F · Catlett, VABuilt 1957 · S/N D-4976N5466RNorthwest Turbine LLC · Spokane, WABuilt 1985 · S/N TJ-497N5466UJasper Aviation Inc · Jasper, ALBuilt 1967 · S/N TD-702N5467DRegistration Pending · Salt Lake City, UTRegistration pendingBuilt 1957 · S/N D-4973N5467USinor Delbert D · Ozark, MOBuilt 1967 · S/N TD-704N5468DWilliamson William R · Asheboro, NCBuilt 1957 · S/N D-4960N5469VSchweers John · Plano, TXBuilt 1967 · S/N D-8565N546CBFlatland Aviation LLC · Satanta, KSS/N E-3489N546DKMcghee Billy H · Deland, FLS/N MB-616N546GAFinch Dennis G Jr DBA · Long Prairie, MNBuilt 1975 · S/N TC-1915N5470DDocter Lloyd W · Tacoma, WABuilt 1957 · S/N D-5020N5471DN5471d LLC · Duluth, MNBuilt 1957 · S/N D-5006N5471GGlenn William · Hilton Head Island, SCBuilt 1978 · S/N E-1338N5471UByrd Pat · Crystal City, TXBuilt 1967 · S/N TG-31N5475DDelta Ridge Farms LLC · Oak Grove, LAS/N D-4994N5476UMagruder Thomas D Jr · Ocean Springs, MSBuilt 1967 · S/N TC-1037N5478DRobb Steven G · Riverside, CABuilt 1957 · S/N D-4985
Back to AD 99-05-13 R1 WD