Skip to content

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N37091Lee James P · Madisonville, TNBuilt 1980 · S/N E-1761 N3710BEndless Mountain Skydivers Inc · Dalton, PAFirst renewal noticeBuilt 1955 · S/N BA-44 N3711NBay Area Concrete LLC · Hayward, CABuilt 1980 · S/N ME-375 N3711WMccaul Benjamin · San Luis Obispo, CABuilt 1980 · S/N E-1762 N37126Robison Charles T · Pierre, SDBuilt 1980 · S/N EA-156 N3713QAirborne Adventures LLC · Clive, IABuilt 1966 · S/N D-8370 N3714STwesme Scott · Lake Mills, WIBuilt 1981 · S/N TC-2356 N3714XBig Bend Community College · Moses Lake, WABuilt 1980 · S/N M-2278 N3714ZQuick Foam Insulation LLC · Lubbock, TXBuilt 1980 · S/N EA-160 N3715CHangar Ten LLC · Westfield Center, OHS/N TC-2391 N3715QShellington Justin R · Columbus, NJBuilt 1966 · S/N D-8375 N3715XBig Bend Community College · Moses Lake, WABuilt 1980 · S/N M-2283 N3716QHoward Michael I · Shelley, IDBuilt 1967 · S/N TE-297 N3717SSetter Thomas · Burnsville, MNS/N BA-196 N37188Charpentier Thomas J · Santee, CAS/N M-2263 N371AKSweeney James J III · Glenwood Springs, COBuilt 1979 · S/N ME-157 N371BBtf Ventures LLC · Kalispell, MTBuilt 1957 · S/N D-5069 N371BBLake Peipsi LLC · Williamstown, WVBuilt 2000 · S/N E-3355 N371RATampa Bay Air Charter LLC · Saint Petersburg, FLS/N E-3590 N3720QM M & O Aviation Inc · Northglenn, COBuilt 1966 · S/N D-8373 N3722BRui C LLC · Reddick, FLBuilt 1955 · S/N CH-152 N37236Nay Richard B · Gunnison, UTBuilt 1981 · S/N EA202 N37240Green Clarence L · Hondo, TXBuilt 1980 · S/N M-2282 N37243Gregory Willie D · Ellenwood, GABuilt 1980 · S/N MC-734 N3724BFlorida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1980 · S/N ME349 N3724DArnold Aviation LLC · Lisle, ILS/N E-3624 N3724HAviation Capital Management LLC · San Jose, CABuilt 1982 · S/N ME-350 N37259Krystofiak Steven · Scottsdale, AZBuilt 1980 · S/N WA-128 N3725XShultz L E · Brentwood, TNBuilt 1980 · S/N WA-114 N3726BThomas Allen Lee · Cedar Rapids, IABuilt 1980 · S/N WA-127 N3726L8s1-51 LLC · Polson, MTBuilt 1994 · S/N CE1787 N3726UPillor Dalton John · Surprise, AZBuilt 1980 · S/N WA-124 N37275Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N WA-129 N37276Fedorenko Vladimir Y · Estacada, ORBuilt 1980 · S/N WA-138 N3727BLonghorn Holding LLC · De Pere, WIBuilt 1980 · S/N WA-133 N3728AAc Bonanza LLC · Carrollton, TXBuilt 1969 · S/N D-9084 N3728GDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N ME-357 N3728KDunham Christopher B · Atlanta, GABuilt 1980 · S/N M-2285 N3729BFredericks William D · Charleston, WVBuilt 1980 · S/N WA-140 N3729DLambert David C · Conway, ARBuilt 1980 · S/N WA-141 N372BSchmalhaus Rodney · Garfield, ARS/N D-5101 N372PSDb Aero Inc · Wilmington, DEBuilt 1964 · S/N BA-693 N3730GMiami Sim Support LLC · Miami Beach, FLS/N MC-736 N3730HFox Valley Aero Club Inc · Oshkosh, WIBuilt 1980 · S/N M-2287 N3730NHealy David Paul · Arlington, TXS/N WA-152 N3730SWingfield Ronald T · Little Rock, ARBuilt 1980 · S/N WA-115 N3731BSf-Gb Enterprises · Shelbyville, KYBuilt 1980 · S/N WA-143 N3731QMoore J D · Lawson, MOBuilt 1966 · S/N D-8374 N37321Hamilton Janet S · Townsend, GABuilt 1980 · S/N M-2288 N3732BMurphy Walter D Trustee · Newcomerstown, OHBuilt 1980 · S/N WA-160

Back to AD 99-05-13 R1 WD