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.

N186BBowen John J · Granbury, TXBuilt 1956 · S/N D-4484N186QExecutive Bonanza Group · Sacramento, CABuilt 1964 · S/N D-7644N186RLN186rl LLC · Fortson, GABuilt 1993 · S/N CE-1748N1870WMahoney Michael A · Daphne, ALBuilt 1973 · S/N E-435N1871DTiehen James P · Huntington Beach, CABuilt 1952 · S/N D-3181N1871WCitationxtango LLC · Kennett Square, PABuilt 1973 · S/N TC-1563N1872LFreeman Gary M · Richmond Hill, GABuilt 1976 · S/N CE-648N1873LJanzen Mark · Chico, CABuilt 1976 · S/N D-9892N1873WDuke Aerospace LLC · Shelbyville, KYBuilt 1973 · S/N P-231N18746Pas Inc · Townsend, DES/N TC-2094N1874LRegistration Pending · Dover, DERegistration pendingBuilt 1976 · S/N CE-649N1875DJohnson Clayton D · Desert Hot Springs, CAS/N D-3118N1875LRib-Cjr Aero LLC · Los Altos Hills, CABuilt 1976 · S/N E-852N1875WN1875w LLC · Nashville, TNBuilt 1973 · S/N E-437N18760Twinfin LLC · Port Orange, FLBuilt 1977 · S/N D-10070N18763Registration Pending · San Jose, CARegistration pendingBuilt 1977 · S/N E-1158N18767Zimmerman Patrick Joseph · Roseburg, ORBuilt 1977 · S/N MC-503N18769Shiel Penny S · Palisade, COBuilt 1977 · S/N MC-500N1876WHeadsets Incorporated · Amarillo, TXBuilt 1973 · S/N CE-443N18770Robinson Jere L · Burnet, TXS/N MC-498N18774Sarasota Avionics Inc · Venice, FLBuilt 1977 · S/N M-1941N18775Chesley Boyd A · Cottonwood, AZS/N MB-846N18777Dunn Larry L · Conway, WABuilt 1938 · S/N 200N1877LShrauner Reid E · Elkhart, KSBuilt 1976 · S/N E-857N18781Morrison Mark · Bloomingdale, ILBuilt 1938 · S/N 204N18782Stagman Andrew A · Land O Lakes, FLBuilt 1977 · S/N MC-505N18783Bates Gary D · Niles, MIBuilt 1977 · S/N M-1945N18785Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1938 · S/N 208N18787Ostrowski Brian Keith · Jerome, MIBuilt 1977 · S/N M-1921N18791Registration Pending · Stevens Point, WIRegistration pendingBuilt 1977 · S/N M-1942N18793Berns Robert D · Clifton, ILBuilt 1977 · S/N MC-506N18795Bock Patrick D · Phoenix, AZBuilt 1977 · S/N M-1947N18798Herald Jason E · Tulsa, OKBuilt 1977 · S/N MC-508N1879LN1879l LLC · Missoula, MTBuilt 1976 · S/N TK-13N187CSNorris Marvin D · Georgetown, TXBuilt 1999 · S/N E-3232N188Gear Robert Lee III · Paradise Valley, AZFirst renewal noticeS/N LC70N1880DAdams Marvin R · Peyton, COBuilt 1952 · S/N D-3151N1880LSouth Regional Aviation Enterprise · Boynton Beach, FLBuilt 1976 · S/N D-9894N1881DHerrell Lynn K · Wichita, KSS/N D-3153N1881LSwept Wing Aviation LLC · Murfreesboro, TNBuilt 1976 · S/N TC-1968N1883LAirflo LLC · Wilmington, DEBuilt 1976 · S/N P-383N18841Quality Aviation Inc · Atlanta, GABuilt 1977 · S/N MC-509N18858Martindale Ian C · Seattle, WABuilt 1977 · S/N MC-510N18859Molnair LLC · Columbus, GABuilt 1977 · S/N MC-511N1885WS35s LLC · Stevens Point, WIBuilt 1973 · S/N D-9485N18861Phillips Gary O · San Rafael, CABuilt 1977 · S/N M-1953N18862Koenig Michael · Mooresville, NCBuilt 1977 · S/N M-1956N18864Burnett Robert J · Garden Valley, CABuilt 1977 · S/N M-1955N18865Shoreline Aviation LLC · Norman, OKBuilt 1977 · S/N MC-514N18867Wisniewski Joseph B · Ormond Beach, FLBuilt 1977 · S/N M-1954
Back to AD 99-05-13 R1 WD