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.

N24136Tj Air Holding Inc Trustee · Wilmington, DEBuilt 1978 · S/N E-1233N24161Diamond Scenery LLC · Red Oak, TXBuilt 1978 · S/N D-10103N24165Yukon Helicopters Inc · Bethel, AKBuilt 1978 · S/N TK-78N24182Robert Yost Enterprises Inc DBA · Saint Francis, KSBuilt 1978 · S/N TJ-136N24183Smither Tom M · Marietta, GABuilt 1978 · S/N D-10107N24192Lindeman Rusty L · D Hanis, TXBuilt 1978 · S/N E-1223N24194Ge King LLC · Lewes, DEBuilt 1978 · S/N E-1222N24195Barrett Group LLC · Farwell, TXBuilt 1978 · S/N D-10110N241GAAdvanced Air Leasing LLC · Kissimmee, FLS/N CE-1447N241HHOddson Terrance J · Windom, MNBuilt 2001 · S/N E-3427N241KRollison James · Scottsdale, AZFirst renewal noticeBuilt 1939 · S/N 287N241NPNauti Plane LLC · Wilton Manors, FLBuilt 1968 · S/N TE-648N241RSalamon Uri · Boerne, TXBuilt 1980 · S/N CE-925N2422MGuyll Jay D · Denville, NJBuilt 1963 · S/N M-256N242FFThomas Leslie R · Kosse, TXBuilt 1971 · S/N D-9220N242HARounds Agronomy LLC · Pierre, SDBuilt 1961 · S/N D-6626N242MFerrell Alan · Arlington, OHBuilt 1963 · S/N D-7112N242MFTruair LLC · Chaska, MNBuilt 1978 · S/N P-465N242RLindley Charles D Jr · Spring, TXBuilt 1982 · S/N CE1001N242SFCurtin Christopher C · Ashburn, VABuilt 1977 · S/N D-10064N2435ACooper Timothy J · Spearman, TXBuilt 1969 · S/N D-9036N243HEason Michael P · Murfreesboro, TNBuilt 1952 · S/N D-3272N244JHDecca Aviation Operations Inc · Lincoln, NEBuilt 1976 · S/N E-818N244JNShepherd Jacob · Lake Havasu City, AZBuilt 1964 · S/N D-7698N244LAcevedo Jesus · North Branford, CTS/N D-2747N24566Carney Travis · Running Springs, CABuilt 1972 · S/N MC-120N24575Strehlow Eugene E · Hettinger, NDBuilt 1972 · S/N MC-123N24581Air Force LLC · Mount Pleasant, SCBuilt 1972 · S/N MC-130N24588Fischer Paul O · Great Falls, MTS/N MC-157N24589J & N Costa Aircraft LLC · Indian Rocks Beach, FLBuilt 1972 · S/N M-1405N2458ALeger Bryan · Gulf Breeze, FLBuilt 1969 · S/N D-9038N24590Nice Flying LLC · Williamsburg, VABuilt 1972 · S/N MB-546N24592Kovac Brett D · Colorado Springs, COS/N M-1547N24595Baisch Troy W · Oceanside, CABuilt 1972 · S/N MB-542N24597Smoketown Flight Center LLC · Smoketown, PABuilt 1972 · S/N MB-549N24598Johnson Jay W · Wichita, KSS/N M-1419N24599Petrie Jerry W · Ozark, ALBuilt 1972 · S/N M-1409N245CERichards William · West Jefferson, OHBuilt 1972 · S/N M-1412N245JCLapoint Gregg F · Skaneateles, NYBuilt 1975 · S/N CE-595N245LIhlenburg Kirk · Tualatin, ORS/N E-2185N245MDawson Jamie Stewart · Celina, TXBuilt 1963 · S/N BA-646N245MJMaensivu Maverick Juha · Apopka, FLS/N MB 814N245RMWrongbros Aviation LLC · West Sacramento, CABuilt 1987 · S/N E-2382N245SWCrosswinds LLC · Opelousas, LABuilt 1982 · S/N E-2018N245TSTexas Recreational Aircraft Club Inc · Houston, TXBuilt 2000 · S/N E-3318N24600League Zachary E · Carter, OKBuilt 1972 · S/N MB-543N24602Mcclain Alex · Camdenton, MOBuilt 1972 · S/N MB-551N24605Deakins Glenn F · Ringgold, GAS/N MB-553N24608Haney Jeffrey B · Carrollton, GABuilt 1972 · S/N MC-142N24615Mclean Aviation LLC · Phoenix, AZS/N M-1406
Back to AD 99-05-13 R1 WD