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.

N564DLBrunson Scott · Mercer, PAS/N TE-474 N564TOgle Jason S · Norris, TNBuilt 1961 · S/N D-6744 N5650LBidzos D James · Reston, VABuilt 1990 · S/N EA505 N5650SOliver Jonathan · Maryville, TNBuilt 1966 · S/N MA-68 N5651KStubblefield Daniel · Chino Hills, CABuilt 1964 · S/N D-7402 N5652LSkelton Thomas Nichols Jr · Jackson, MSBuilt 1977 · S/N MC-533 N56539Six 27 Properties LLC · Flint, TXBuilt 1990 · S/N E2539 N5653SSellers Alton H · Savannah, GABuilt 1966 · S/N MA-79 N5654SWilcox Ryan · Brookland, ARBuilt 1966 · S/N MA-80 N5655NWiley Aviation LLC · Saint Augustine, FLBuilt 1990 · S/N CE-1464 N5656KTompkins Wyatt M · Pearland, TXBuilt 1964 · S/N TC-756 N5657KWatson Robin G · Eastsound, WABuilt 1964 · S/N D-7593 N565BPClark Giles R Jr · Magnolia, TXBuilt 1967 · S/N TE-405 N565MJse Aviation LLC · Franklin, NHBuilt 1990 · S/N E-2525 N565PAero Cruz LLC · Agoura Hills, CABuilt 1999 · S/N E-3280 N5660SRussek Ron · Cleburne, TXFirst renewal noticeBuilt 1966 · S/N MB-101 N5661KShockey David Allen · Deland, FLBuilt 1964 · S/N D-7592 N5662KGiddings Melvin J Jr · Vacaville, CABuilt 1964 · S/N D-7588 N5667SParsons John C · Wichita, KSBuilt 1966 · S/N MB-106 N5668DLetzelter C J · Littleton, COBuilt 1959 · S/N BA-416 N5668KMonroe Shannon · Bellevue, WABuilt 1964 · S/N D-7601 N5669KYankee Airmen Inc · Torrance, CABuilt 1964 · S/N D-7656 N566CCarolina Contrails LLC · Pine Knoll Shores, NCS/N E-3621 N5671SMusketeer Aviation Inc · Potterville, MIBuilt 1966 · S/N MB-110 N5672SHogan Jacob A · Canon City, COBuilt 1966 · S/N MA-82 N5674KCmt Properties LLC · Laurel, MSS/N TD-586 N5676KDevlin Jeff M · Seattle, WABuilt 1964 · S/N D-7602 N5677XKas Properties LLC · Jennings, LABuilt 1993 · S/N E-2797 N5679SWinters Kevin L · Nine Mile Falls, WABuilt 1966 · S/N MB-122 N567EBAlman Inc · Fort Lauderdale, FLBuilt 1979 · S/N E-1543 N567ETMusick Aircraft Corp · Greenwood, MSBuilt 1975 · S/N TC-1866 N567JL2fly-Safety LLC Trustee · Azle, TXBuilt 1974 · S/N TC-1718 N567MShower Brenden C · Raleigh, NCBuilt 1979 · S/N CE-854 N567RMRonald J Mazzolz Inc · San Diego, CAS/N EA-282 N567RSSpitler Robin C · Statesboro, GABuilt 1967 · S/N D-8575 N567TMLucke & Associates Cpas Lc · Wichita, KSBuilt 1998 · S/N EA-627 N567TSTango Sierra LLC · Scottsbluff, NEBuilt 1984 · S/N E-2173 N567UPDodson Robert B · Harvard, ILBuilt 1957 · S/N D-5010 N5681SHillcrest Aviation LLC · Midland, TXBuilt 1966 · S/N MA-91 N5685SGreen Taylor · Olympia, WABuilt 1966 · S/N MB-125 N5687SRobbins Warren N · Chandler, AZBuilt 1966 · S/N MB-127 N5688KRouw Bruce L · Leesburg, FLBuilt 1964 · S/N TC-765 N5688STanneberg Larry · Coulee City, WABuilt 1966 · S/N MB-128 N5689DKelly G L · Blacksburg, VAS/N D-6482 N568PBas Part Sales LLC · Greeley, COS/N TC-2162 N5691KRegistration Pending · Shady Shores, TXRegistration pendingBuilt 1964 · S/N D-7619 N5692KBeyer Greg R · Buffalo, MNBuilt 1964 · S/N D-7621 N5693KTateshima Satoshi · Los Angeles, CABuilt 1964 · S/N D-7625 N5693SChupp David · Abbeville, SCBuilt 1966 · S/N MA-94 N5696KLokey Kenneth R · Austin, TXBuilt 1964 · S/N D-7628

Back to AD 99-05-13 R1 WD