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.

N5137MFuture Pilots Of America Flight Academy LLC · Baxley, GABuilt 1978 · S/N MB-890 N5138CBean Bonnie J · Surprise, AZS/N D-2423 N5138MDl Squared LLC · Fulton, MOBuilt 1978 · S/N MC-579 N5139CTorkelson Charles A · San Antonio, TXBuilt 1950 · S/N D-2424 N513RCraddock Roger D · Memphis, TNBuilt 1961 · S/N D-6782 N5140CGeantil Thomas G · San Diego, CABuilt 1950 · S/N D-2425 N5145CWard Austin L · Kokomo, INBuilt 1950 · S/N D-2430 N514AVDigirolamo Anthony S · Stow, MABuilt 1979 · S/N CE846 N514BKNot For Naught LLC · Wimberley, TXBuilt 1974 · S/N E-514 N514CSTomco Stores Ltd · Ruidoso, NMBuilt 1964 · S/N D-7533 N514HRSethi Inderdeep Singh · Tracy, CABuilt 1980 · S/N EA-70 N514JBSchneider Stephen C · Denton, TXBuilt 1969 · S/N TC-1263 N514KValentin Arnaldo J · Bayamon, PRBuilt 1958 · S/N D-5566 N514KCPerazzola Carl J · Bonaire, GABuilt 1966 · S/N TE-82 N514PCParsons Donald E · Clarksville, TNBuilt 1969 · S/N D-8967 N5150EM & M Aviation Enterprises LLC · Springfield, MOS/N E-3412 N5154MTx Waste Ventures LLC · Caddo Mills, TXBuilt 1978 · S/N M-2037 N5155MGreenbirds LLC · Apopka, FLBuilt 1978 · S/N M-2038 N5158CSmith Edward I · Suffolk, VABuilt 1950 · S/N D-2443 N5158MLenox Jeffrey D · Livingston, TXBuilt 1978 · S/N M-2042 N5159CAircraft Partner Holdings Inc Trustee · BerlinS/N D-2444 N5159MThunder Wings LLC · Wilmington, DEBuilt 1978 · S/N M-2041 N515BTurnkey Design Build LLC · Sarasota, FLFirst renewal noticeBuilt 1948 · S/N D-1539 N515EKSolomon Paul T · Cleburne, TXBuilt 1984 · S/N EA-440 N515PDSeals Welding & Fabircating Inc · Oxford, ALBuilt 1990 · S/N CE-1532 N515RJFroehlich Franz M · Oceanside, CABuilt 1983 · S/N EA-357 N515TGMilton Steven Pichon · Houston, TXBuilt 1994 · S/N EA-570 N5160CCollins Robert E · Belleville, ILBuilt 1950 · S/N D-2445 N5161MSamora Bobby · Corona, CAFirst renewal noticeBuilt 1978 · S/N M-2039 N5162MCorcoran Thomas A · Braintree, MABuilt 1978 · S/N M-2040 N5164MChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-50 N5165CHuskey James R · Guthrie, OKBuilt 1950 · S/N D-2450 N5166MSun City Aviation LLC · Davie, FLBuilt 1978 · S/N ME-46 N5167MTuggle Casey · Chattanooga, TNS/N M-2043 N51685Midland Avionics LLC · Louisville, KYS/N LC-40 N5169MEngdahl Thomas L · Rohnert Park, CABuilt 1978 · S/N MC-584 N516MSSouth Bay Aviation Inc · Torrance, CABuilt 1979 · S/N ME-166 N516QMonahans Affordable Homes LLC · Monahans, TXBuilt 1967 · S/N TG-20 N516SABaron Aircraft Corporation · Richmond, VABuilt 1969 · S/N TC-1268 N516WClearwater Holding LLC · Parkersburg, WVBuilt 1975 · S/N D9744 N5170CMcgrath Patrick G · Auburn, KSBuilt 1950 · S/N D-2455 N5170MWheeler David A · York, PABuilt 1978 · S/N M-2050 N5171CGump Check LLC · New Port Richey, FLBuilt 1950 · S/N D-2456 N5172Beitler William J · Washington, PABuilt 1955 · S/N G-729 N51746Nichols Charles F Trustee · Baldwin Park, CABuilt 1943 · S/N 4890 N5174CHamlin Jeffry S · Double Oak, TXBuilt 1950 · S/N D-2585 N5175CW Graber Contracting LLC · Amboy, INBuilt 1950 · S/N D-2400 N5177MElh Aviation LLC · Flint, MIBuilt 1977 · S/N TJ-116 N5178CReid Brian S · Merced, CABuilt 1950 · S/N D-2460 N517DJUrquhart Dan DBA · Fallon, NVBuilt 1997 · S/N E-3075

Back to AD 99-05-13 R1 WD