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.

N3684ARegistered aircraftBuilt 1980 · S/N CE-916 N3684HAvex X Corp · Coral Gables, FLBuilt 1981 · S/N TE-1180 N3684QDesmarais Arthur G · Gilford, NHBuilt 1967 · S/N M-1056 N3684YBluebird Holdings LLC · Morris, MNFirst renewal noticeBuilt 1980 · S/N TJ-298 N36855Aerial Digital Images LLC · Huntington Beach, CABuilt 1980 · S/N EA-117 N3685QEaston Bryan L · Council Bluffs, IAS/N MA-259 N3685WJewell Warren · Seattle, WABuilt 1980 · S/N EA-113 N36877Stilwell Aviation LLC · Stilwell, KSBuilt 1980 · S/N EA-119 N3687QHjelle Tim D · Malone, WIBuilt 1967 · S/N MA-270 N36884Main Aviation Inc · Visalia, CABuilt 1980 · S/N EA-121 N3688QFour Musketeers LLC · Wichita, KSBuilt 1967 · S/N MA-272 N3688RMckay Christopher · Point Arena, CAS/N CE-918 N3689QBusick Aviation LLC · England, ARBuilt 1967 · S/N MA-271 N3689ULeonard Robert E · Mattoon, ILBuilt 1980 · S/N E-1733 N368BVinnola Bruce L · Glenrock, WYBuilt 1957 · S/N D-5107 N368BWYarak Six LLC · Berkeley, CAFirst renewal noticeBuilt 1974 · S/N P-290 N368HPHigh Performance Aircraft Inc · El Cajon, CABuilt 1981 · S/N E-1833 N368JHUrsine L Attitudes Ltd · Richland, WABuilt 1981 · S/N E-1920 N368POfferaire Inc · Lebanon, NJBuilt 1995 · S/N E-2942 N36900Bas Part Sales LLC · Greeley, COBuilt 1980 · S/N E-1739 N3690DR B M Corporation · Cropwell, ALBuilt 1980 · S/N TJ-306 N3690NDetraglia Michael C · Canandaigua, NYBuilt 1980 · S/N EA-123 N3691QKempf David V · San Tan Valley, AZS/N MA-276 N3692ABva Bonanza LLC · Keizer, ORBuilt 1969 · S/N D-9091 N3692XLake Elmo Aero LLC · Lake Elmo, MNBuilt 1981 · S/N ME-369 N36939Holtzen Farms Inc · Jerome, IDBuilt 1980 · S/N EA-129 N3693AC And F Enterprise L L C · Milford, MIBuilt 1964 · S/N D-7384 N3694DAircraft & Interiors @ Klns Ltd · Brownstown, PAExpired dealer, pending cancellationBuilt 1980 · S/N P-552 N36958N36zz LLC · Parkland, FLBuilt 1980 · S/N EA-137 N3695LBg Aviation LLC · Waukesha, WIFirst renewal noticeBuilt 1980 · S/N TC-2353 N36968Msb Aviation LLC · Middletown, DEBuilt 1980 · S/N CE-924 N3696LP51d Mustang LLC · Bigfork, MTBuilt 1980 · S/N TJ-310 N3697YSmotrich Gary A · Yardley, PABuilt 1980 · S/N M-2294 N3698D98d Aviation LLC · Dyersburg, TNBuilt 1980 · S/N E1746XL N3698QGribble David A · Marion, IABuilt 1967 · S/N MA-281 N3699AWeskap Hangar Management LLC · West Grove, PABuilt 1979 · S/N E-1621 N3699GInternational Aerospace Solutions LLC · Jupiter Inlet, FLBuilt 1980 · S/N EA-151 N3699QHillner Kevin D · Marengo, ILS/N MA-282 N369BBRandigo LLC · Wilmington, DEFirst renewal noticeBuilt 1967 · S/N TD-713 N369KMHoon David DBA · Wolf Creek, MTBuilt 1972 · S/N TC-1501 N369RBWorman Cody Gene · Fort Wayne, INS/N D-2384 N369SACaton William D · Irving, TXBuilt 2001 · S/N E-3369 N36AOral & Maxillofacial Surgery Of Carbondale Inc · Carbondale, ILBuilt 1958 · S/N D-5451 N36AAPortnoy Ralph · Hollywood, MDBuilt 1978 · S/N E-1217 N36ABNg Turf LLC · Whitesburg, GABuilt 1979 · S/N E-1560 N36AESokolowski Daniel J · Clear Lake, IAS/N G-77 N36AJFurst A J · Coral Gables, FLBuilt 1992 · S/N EA-532 N36ARArkansas Department Of Aeronautics · Little Rock, ARBuilt 1991 · S/N E-2620 N36ASMoore Brothers Company Inc · Staunton, VABuilt 1977 · S/N E-1009 N36AXNorth Flight Air LLC · Ann Arbor, MIBuilt 1990 · S/N E-2579

Back to AD 99-05-13 R1 WD