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.

N4528VHagglund Carl D · Pendleton, ORBuilt 1948 · S/N D-1352N4533VStraight Fly LLC · West Jordan, UTS/N D-1359N4546VThwing Randy L · Las Vegas, NVFirst renewal noticeBuilt 1948 · S/N D-1373N455BYasky Richard J · Seaford, VABuilt 1948 · S/N D-1472N4560VCrane Russell S · Poplar Grove, ILBuilt 1948 · S/N D-1389N456BOr Meir Aviation · Youngstown, OHNon-citizen corporation, flight hours not reportedBuilt 1948 · S/N D-1473N4578VMcpeck Adam S · Agar, SDFirst renewal noticeS/N D-1244N4579VGcb Services LLC · Jacksonville, ORBuilt 1947 · S/N D-1221N4584VHarrison Megan · Des Moines, IABuilt 1947 · S/N D-1052N458BSwensson Sean C · Alpine, CABuilt 1948 · S/N D-1475N4598VLandwell Pllc · Lake Havasu City, AZBuilt 1947 · S/N D-1151N461BNottingham Jeff · Fuquay Varina, NCBuilt 1948 · S/N D-1631N4640SWeeks Stan Jr · Taneyville, MOBuilt 1964 · S/N D-2308N4650VPhillips James A · Lake Arrowhead, CABuilt 1952 · S/N D-457N468BCassels William E · Phoenix, AZBuilt 1947 · S/N D-1120N46WSCahoon Theodore J · Erie, COBuilt 1948 · S/N D-1253N473ABTake Flight Aviation LLC · Grand Forks, NDBuilt 1948 · S/N D-1578N475BVinyard Robert L Jr · Borger, TXBuilt 1948 · S/N D-1493N47LLSmith Roy H · Garberville, CABuilt 1947 · S/N D-972N47RBHolley Jack F · Morehead, KYS/N D-368N47VBTautology Ltd · Longmont, COS/N D-936N47VTBoyes Brothers Partnership · Benton City, MOBuilt 1947 · S/N D-730N47WAHughston Chris · Brentwood, TNBuilt 1947 · S/N D-155N480ASArizona Air Salvage · Phoenix, AZFirst renewal noticeBuilt 1949 · S/N D-2124N486BSale Reported · Nixa, MOSale reportedS/N D-1506N489EJerrolds Skye S · Knoxville, TNBuilt 1948 · S/N D-1509N48CBWells Bryan G · Stephenville, TXBuilt 1950 · S/N D-2203N48JBN48jb LLC · Imperial, MOBuilt 1948 · S/N D-1371N490PAnthony Ballone · Tulsa, OKRevoked, canceledBuilt 1948 · S/N D-1510N494BStutzman Frank C · Caldwell, IDBuilt 1948 · S/N D-1514N497BWillis James R · Belleview, FLBuilt 1948 · S/N D-1518N5008CMckenna Kent T · Torrance, CAFirst renewal noticeBuilt 1950 · S/N D-2270N5010CPhemister Ricky D · Breckenridge, TXS/N D-2382N5011CSimecek Keith A · Milan, MIBuilt 1950 · S/N D-2273N5015CKrueger Hendrik Jacobus · Rockport, TXS/N D-2277N5017CFurman Tyler L · Alliance, NEBuilt 1950 · S/N D-2279N5018CDutcher Paul G · Hesperus, COBuilt 1950 · S/N D-2280N5032CGann Mark E · Springfield, MOBuilt 1950 · S/N D-2294N5034CCoen Rayce P · Wiley, COBuilt 1950 · S/N D-2296N5036CPilot & Co Aviation LLC · Artesia, NMFirst renewal noticeBuilt 1950 · S/N D-2298N5039CGreedy Michael L · Carson City, NVBuilt 1950 · S/N D-2301N5041CEngelhardt John · Porter, TXBuilt 1950 · S/N D-2303N5042CVehrs Larry A · Independence, ORBuilt 1950 · S/N D-2304N5048CKemp Steve W · Albuquerque, NMBuilt 1950 · S/N D-2377N504BYeagley Daun E II · Wilmington, OHBuilt 1948 · S/N D-1526N5055CTaylor Kenneth R · Seminole, OKBuilt 1950 · S/N D-2317N505BLeyda Aaron M · Bartlesville, OKBuilt 1948 · S/N D-1528N5063CMoore Israel T · Pasco, WABuilt 1950 · S/N D-2325N5065CYonge Robert R · Ocala, FLBuilt 1950 · S/N D-2327N5068CImagine Help · Oxnard, CABuilt 1950 · S/N D-2330
Back to AD 2002-21-13