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.

N3870BFresneda Rafael Ruiz · Daytona Beach, FLS/N D-4150 N3870UJsn Aviation LLC · Huntersville, NCBuilt 1981 · S/N WA-260 N3870ZAndrew Fishback LLC · Palmyra, MOS/N MC-757 N3871UHolly Factory · Alachua, FLBuilt 1981 · S/N EA-220 N3872BLucarelli David L · Moncks Corner, SCBuilt 1955 · S/N D-4137 N3872URegistered aircraftBuilt 1981 · S/N M-2239 N3872W6 Chicks Aviation LLC · Santa Maria, CABuilt 1981 · S/N EA-225 N3873JSalters James C · Montgomery, OHBuilt 1981 · S/N E-1855 N3873LScott Terry Dale · Yerington, NVBuilt 1981 · S/N E-1857 N3874BLong Lawrence R · South Whitley, INBuilt 1955 · S/N D-4172 N3875BRegistration Pending · Spokane, WARegistration pendingBuilt 1955 · S/N D-4198 N3876CSoar International LLC · Olive Branch, MSBuilt 1979 · S/N P-513 N3877BWilliams Danny J · Mabelvale, ARS/N D-4140 N387JKTaylor Jason E · Keller, TXBuilt 1980 · S/N E-1638 N387JRThree Eight Seven Jr LLC · Sunray, TXBuilt 2001 · S/N E-3393 N3880BStiles David W · Saint Petersburg, FLS/N D-4133 N3887BDouglas Steven L · Huntsville, ALBuilt 1955 · S/N D-4163 N388BCAerospace Trust Management LLC · Wilmington, DEBuilt 1975 · S/N D-9786 N388FMcquillin Transport LLC · Lecompte, LABuilt 1989 · S/N CE1334 N388GBInternational Air Services Inc Trustee · Carson City, NVBuilt 1951 · S/N D-2761 N388PRicardo Barrantes Consulting Inc · Mount Dora, FLBuilt 1980 · S/N E-1778 N3892BKirvida James · Hudson, WIBuilt 1955 · S/N D-4171 N3893BEngel Carson D Trustee · Amboy, INBuilt 1955 · S/N D-4177 N3894BBishop Ernie · Los Angeles, CABuilt 1955 · S/N D-4179 N3896BAlden K Butcher Autioneering LLC · Jane Lew, WVBuilt 1955 · S/N D-4146 N3897BDiamond Stephen C · West Bloomfield, MIBuilt 1955 · S/N D-4304 N3898BHenson Larry B · Haslet, TXBuilt 1955 · S/N D-4376 N3899BJohnston Robert M · Plantation, FLBuilt 1955 · S/N D-4135 N389MCCarstetter Melvin D · Lakebay, WABuilt 1978 · S/N D-10150 N389SLively Kirk D · Cresson, TXBuilt 1969 · S/N D-9083 N389ZSmith Daniel P · Saint George, UTBuilt 1960 · S/N D-6561 N38BTMccully Bruce F · Nashville, TNS/N D-7261 N38BWRed Cloud Aviation LLC · Shawnee, OKBuilt 1965 · S/N BA-725 N38DKCullinan Robert B · Rch Palos Vrd, CABuilt 1965 · S/N D-7899 N38MMMusko Richard M · Wilkes Barre, PABuilt 1955 · S/N CH-297 N38NHendrix Stuart Brent Trustee · Atascadero, CABuilt 1973 · S/N P-220 N38NTYorkavitz James B · Valley City, OHBuilt 1980 · S/N TJ-270 N38PKDeininger Robert · Apopka, FLS/N EA-467 N38RCharliefoxtrot LLC · Farmington, MOBuilt 1973 · S/N TC-1541 N38RDBowser Adam L · Lake City, FLBuilt 1954 · S/N D-3868 N38RRClark Martin B · Dayton, OHBuilt 1976 · S/N E-815 N38SSKane Of The Upstate · Greenville, SCS/N E-544 N38WSilverbird Vintage Aircraft & Flying Services LLC · Zeeland, MIBuilt 1960 · S/N BA-580 N38WBEighttwotwo LLC · Wilmington, DEBuilt 1980 · S/N E-1780 N38WGOneal Eric T · Geneva, FLBuilt 1970 · S/N TE-811 N3902ACountry Trail LLC · Asheville, NCBuilt 1970 · S/N TE-786 N390BMontoya Aviation LLC · Glenview, ILBuilt 1957 · S/N D-4974 N390HWRojecki Stephen T Trustee · Navarre, FLBuilt 1967 · S/N D-8608 N390LFAcadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1989 · S/N CE-1378 N390VKuehler Jon · Amarillo, TXS/N BA-419

Back to AD 99-05-13 R1 WD