OpenAirDocs.org
AD 62-24-03

Registered aircraft · 2,980

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

N1003KScott Michelle · Vallejo, CABuilt 1946 · S/N 3730N101GRAlshamari Ahmad M · San Mateo, CABuilt 1946 · S/N 9749N1044GVoelkerding William Michael · Fairbanks, AKS/N 14403N1050KLynden Aeronautical Services LLC · Lynden, WABuilt 1946 · S/N 3777N10534Shergi Nikolai W · Franklin, INS/N 15697N1078KClairday Preston H · Melbourne, ARS/N 3805N1103DOber John A · Candor, NYBuilt 1950 · S/N 15663N1104DRymill Mark R · Belmont, CABuilt 1950 · S/N 15664N1105DGilman Larry E · Reno, NVBuilt 1950 · S/N 15665N1106DMurdock Mark F · Ketchikan, AKBuilt 1950 · S/N 15666N1108DReddout Terry L Trustee · Wichita, KSS/N 15668N1109BWeymouth James H · Jackson, MIBuilt 1947 · S/N 5736N1109DMcqueen Alan G · Cocoa, FLBuilt 1950 · S/N 15669N110QSilvaire Air LLC · Gun Barrel City, TXBuilt 1948 · S/N 5983N110SLaysoncraft LLC · Clarkston, MIBuilt 1960 · S/N S-79N110VSbur David A · Vancouver, WABuilt 1946 · S/N 8748N110XPlayter Bud W DBA · Gowen, MIBuilt 1946 · S/N 10449N1112DMurray Russell J · Fresno, CAS/N 15676N1113BSky Monkey Tailwheels LLC · Richardson, TXBuilt 1947 · S/N 5740N1114BGiddens Ronald E · Boynton Beach, FLS/N 5741N1115BBradley Lawrence A · Lafayette, CAS/N 5742N1116DOxman Warren L · Rhome, TXS/N 15680N1118BFraser Christopher D · Gig Harbor, WABuilt 1947 · S/N 5745N1119DChumble Ameya A · Duluth, MNBuilt 1951 · S/N 15683N111GZRabinowitz Warren · Ramrod Key, FLS/N 14756N111NZBlackerby Kevin W · Spicewood, TXBuilt 1947 · S/N 12372N1121DVancuren Mary Ann · Owasso, OKBuilt 1950 · S/N 15685N1122DBeech O Sphere LLC · Casper, WYS/N 15686N1125DStarr Eric M · Queen Creek, AZBuilt 1951 · S/N 15689N1126DHynds Michelle S · Addison, TXBuilt 1951 · S/N 15675N1129DKogl John L · Valparaiso, INBuilt 1951 · S/N 15692N1133DBohl Howard M · Temecula, CABuilt 1951 · S/N 15696N1135DRodriguez Daniel Royo · Hagerstown, MDBuilt 1951 · S/N 15698N1136DWatson Frank H · Central Point, ORBuilt 1951 · S/N 15699N1139DOborny Alan R · Choteau, MTBuilt 1951 · S/N 15702N1141DKilo Mushroom Aeronautics Inc · Renton, WABuilt 1951 · S/N 15704N1142DSale Reported · Fayetteville, WVSale reportedBuilt 1951 · S/N 15705N1143DSwanland Robert C · San Jose, CABuilt 1951 · S/N 15706N1143UOman Lee · Sequim, WAS/N 11652N1145KSheehan Sean M · Hampstead, NCBuilt 1946 · S/N 3872N1147QGraber Quinten R · Brooksville, MSBuilt 1947 · S/N 12785N1148DBohl Howard M · Temecula, CABuilt 1951 · S/N 15711N1150DFlight Time Pathways · Forest Lake, MNBuilt 1951 · S/N 15713N1151DWelborn Mark G · Boonville, NCBuilt 1951 · S/N 15714N1153DCarbonaro Joseph J Jr · Lexington Park, MDBuilt 1951 · S/N 15716N115JFFields Joseph H · Placerville, CAS/N 13498N1160BMees Martin B · Eagle River, AKBuilt 1947 · S/N 5787N1161DJefferies Stanley J · Coos Bay, ORS/N 15724N1162KKruckeberg Leroy A · Sanford, NCBuilt 1946 · S/N 3889N1183KRobinson Stephanie L · Ventura, CABuilt 1946 · S/N 3910
Back to AD 62-24-03