OpenAirDocs.org
AD 2002-21-13

Registered aircraft · 579

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:2002-21-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-21-13')
  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.

N680BChisum Robert · Lorenzo, TXS/N D-1683N681BClatterbuck Guy E Jr · Springfield, VABuilt 1948 · S/N D-1684N685BWeeks Stanley III · Taneyville, MOBuilt 1948 · S/N D-1688N686BParsley Randy H · Mc Kenzie, TNBuilt 1948 · S/N D-1689N688BBellas Business LLC · Amarillo, TXS/N D-1691N689BRichter Lawrence J · Lake City, FLBuilt 1948 · S/N D-1692N693BCadaval Manuel · Laguna Hills, CABuilt 1948 · S/N D-1696N694BKalvoda Charles B · Mandan, NDBuilt 1948 · S/N D-1697N699GSBingham Allan S · Rock Springs, WYBuilt 1949 · S/N D-1976N6FCMerriam Lowell G · Chowchilla, CAS/N D2461N700BDonnell James C · Crowville, LABuilt 1948 · S/N D-1703N703BNassour Aviation Inc · Ellisville, MSBuilt 1948 · S/N D-1708N705BBox William C · Goldsby, OKS/N D-1710N706BCazares Tyler A · Weldon, CAS/N D-1711N711BStoner Brian · Puryear, TNBuilt 1948 · S/N D-1716N711LBSale Reported · Brunswick, GASale reportedS/N D-1695N712BBates John W · Westerly, RIBuilt 1948 · S/N D-1717N715RGReynolds Jeffery A · Amarillo, TXS/N D1718N717BCarmickle Patrick M · Tekonsha, MIS/N D-1724N723BBell Bruce B · Lubbock, TXBuilt 1948 · S/N D-1730N725BRussell Charlie N · Palestine, TXBuilt 1948 · S/N D-1732N732BWalton Robert A · Des Moines, IABuilt 1948 · S/N D-1739N734BBallard William · Keller, TXBuilt 1948 · S/N D-1741N738BPockrus Pat B · Mineral Wells, TXBuilt 1948 · S/N D-1744N743BSauls Emily A · La Vernia, TXBuilt 1948 · S/N D-1749N744BGraves Bryan G Sr · Madisonville, TNBuilt 1948 · S/N D-1750N747BBallard Ralph T · Hurricane, UTBuilt 1948 · S/N D-1755N748BMckinney Mark L · Naperville, ILBuilt 1948 · S/N D-1756N74SCGreen Michael B · Kent, WAS/N D-432N756BFrymire Terry R · Floresville, TXS/N D-1764N7607BTechnical Education Services Inc · Virginia Beach, VABuilt 1947 · S/N D-854N760BShorter David A · Duncan, OKBuilt 1948 · S/N D-1768N761BMyron Wayne R · Ione, WABuilt 1948 · S/N D-1769N763BE-Commerce Education Foundation · Tulsa, OKBuilt 1948 · S/N D-1702N767BHughes Coby D · Collinsville, OKBuilt 1948 · S/N D-1775N7707Warner Jon A · Santa Barbara, CABuilt 1950 · S/N D-2535N770BCacic Aviation Inc · Montello, WIS/N D-1778N771NHeitzman Gordon E · White Bear Lake, MNBuilt 1947 · S/N D-1082N772BCox Bryan L · Greensboro, NCS/N D-1782N776BGas Corporation Of America · Wichita Falls, TXS/N D-1786N776RFTrzcinski Douglas R · Chesapeake, VABuilt 1949 · S/N D-2082N777BLexair Corporate Aviation · Miami, FLBuilt 1948 · S/N D-1787N777JCPrimiani Maurizio · Great Falls, MTS/N D-685N7889Missing Link Gravel LLC · Glasgow, MTBuilt 1949 · S/N D-2089N78YBNovember Sierra Aviation LLC · O'Neill, NES/N D-2493N795BTwo Motor Odor LLC · Paris, TXBuilt 1948 · S/N D-1807N796BStarnes Robert D · Lavonia, GAS/N D-1808N797BLong E V · Wichita, KSBuilt 1948 · S/N D-1809N798BVaughn Ken W · Fort Bragg, CAS/N D-1810N80404Hart Aviation LLC · Emory, TXS/N D-4
Back to AD 2002-21-13