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.

N6553V44hw LLC · Shreveport, LABuilt 1967 · S/N D-8625 N6554VXwgnfc LLC · Horsham, PABuilt 1967 · S/N D-8624 N6558Metropolitan Airport Authority · Moline, ILS/N 85 N6558RAntonucci Donald · Barkhamsted, CTBuilt 1974 · S/N MC-294 N6559Watson Charles R Jr · Austin, TXBuilt 1980 · S/N CE-877 N65594Big Wing Nut Inc · Huntington, NYBuilt 1944 · S/N 3097 N655BCritical Craft Technologies LLC · Charlotte Hall, MDBuilt 1948 · S/N D-1654 N655DKhaled Zaky · Parker, COBuilt 1951 · S/N D-2923 N655DDWarren Jason J · Silverdale, WABuilt 1988 · S/N CE-1263 N655JDaum Colton A · Scottsbluff, NEBuilt 1968 · S/N TC-1090 N655QNickson Ted B · Oneida, TNBuilt 1959 · S/N D-5862 N655RJBostic Curtis E · Prestonsburg, KYBuilt 1970 · S/N TC-1331 N655TWilliams Terry J · Owasso, OKBuilt 1972 · S/N E-328 N6560RBurgett William J · Juneau, AKBuilt 1974 · S/N MB-722 N6562RChavis Martin R · Laurel Hill, NCBuilt 1974 · S/N M-1614 N6564DSan Antonio Prop Slingers LLC · La Vernia, TXBuilt 1982 · S/N E-2048 N6564RKuertz Enterprise Ltd · Wilmington, DEBuilt 1974 · S/N MC-301 N6565RAldarondo Luis A · Corvallis, ORBuilt 1974 · S/N MC-302 N6569RMartin Brewster D · Saint Clairsville, OHBuilt 1974 · S/N MC-299 N6569TGarretson Mark W · Victoria, TXBuilt 1968 · S/N M-1144 N656DBartlett Robert · Cleveland, TXBuilt 1951 · S/N D-2924 N656PTSittig Frances M Trustee · Centennial, COBuilt 1959 · S/N D-5910 N6570LHack Mark K · Chatsworth, GABuilt 1983 · S/N M-2379 N6570RBellas Business LLC · Kalispell, MTBuilt 1974 · S/N MC-298 N6576SBeech Aviators LLC · Brookings, SDBuilt 1976 · S/N E-803 N6578RGrinnell Herbert W · Oroville, CABuilt 1974 · S/N MB-729 N657VSPuccio Serge · Houston, TXS/N CJ-4 N6580XSouthwest Aerial Survey LLC · Carlsbad, CABuilt 1983 · S/N EA-341 N6581RMyrtle Beach Dustless Blasting Llp · Loris, SCBuilt 1975 · S/N MC-303 N6582QHuss M Stephen M D · Decatur, ILBuilt 1983 · S/N E-2068 N6582RFca Flight Training And Aircraft Maintenance Inc · Wshngtn Ct Hs, OHBuilt 1974 · S/N MC-304 N6584TCaufman Richard D · Corry, PAS/N MB-369 N6585XNorthbay Consulting LLC · Bellevue, WABuilt 1983 · S/N EA-340 N65873Carpenter Steve · Batesville, ARBuilt 1983 · S/N EA-342 N6588RAugust Aero LLC · Kalispell, MTBuilt 1974 · S/N MC-251 N6589RBradley Mark S · Holly, MIBuilt 1975 · S/N MB-731 N658JSTwo River Airspray LLC · Cavalier, NDBuilt 1977 · S/N TJ100 N658MWitherington Properties Inc · Oak Ridge, TNBuilt 1982 · S/N TJ429 N659Gulf South America Air Transport Inc · Mobile, ALS/N LC72 N6590AJ Robert Finley And Associates Inc · Mountain Home, ARBuilt 1983 · S/N M-2380 N6591AHerk Aviation LLC · New Bern, NCBuilt 1983 · S/N M-2381 N6592RSchmidt Louis J · Orange, CABuilt 1974 · S/N MC-308 N6593RZwicker Brian · Richmond Hill, GABuilt 1974 · S/N M-1602 N6594RBig Bend Community College · Moses Lake, WABuilt 1974 · S/N MB-718 N6595RBig Bend Community College · Moses Lake, WABuilt 1974 · S/N MB-714 N659KRocky Mountain Warbirds LLC · Littleton, COBuilt 1955 · S/N G-830 N659QStennett Kevin · Lockney, TXBuilt 1959 · S/N D-5902 N659TLucy Donald E III · Newbury Park, CABuilt 1972 · S/N D-9357 N65ACCraft Charles Edward · Shepherdstown, WVBuilt 1966 · S/N TE-242 N65AJAitkens Larry · Port Saint Lucie, FLBuilt 1966 · S/N D-8099

Back to AD 99-05-13 R1 WD