AD 63-13-01
Registered aircraft · 1,653
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:63-13-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:63-13-01')
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:63-13-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:63-13-01') 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.
N1314NBuermann Henry · Brookfield, VTN1315NDevries Douglas F · Everett, WAN13244Alacoast Vintage Biplanes LLC · Irvington, ALN1327MMbs Aviation LLC · Topsail Beach, NCN1329MStahl John · Union Dale, PAN1339MKroenlein Donald G · Moweaqua, ILN133RKent Carroll G · Newborn, GAN1342MSkys Unlymited Inc · Wilmington, DEN1343MMehrer Fritz J · Oceanside, CAN1344MJohnson Lawrence F · Colville, WAFirst renewal noticeN1344VPlane Fun Inc Tr (Trustee) · Snellville, GAN1346MT J Air Holdings Inc Trustee · Wilmington, DEN1347VHolder James C · Leonard, TXN1349MSmith Robert F · Fort Valley, GAN1357NGibbs Robert I · Ravenswood, WVN1358MGottron Gregory · Williamson, GAN1359NWiplinger Robert · Inver Grove Height, MNN1361NZiebarth W Richard · Powell, OHN1363VLil Dawg Aviation LLC · Wilmington, DEN1366VCushing Sean M · Howell, MIN1370VBald Eagle Aviation LLC · West Chester, PAN1371VWilson Archie C · Hernando, FLN13787Yandik Stephen E · Hudson, NYN1379VBallard Rickey G · Buckeye, AZN1383VNorthington Neill · Fredericksburg, TXN1387VAmerican Airpower Heritage Flyingmu · Dallas, TXN1390NOnstott Norman V · Mt Pleasant, MIN13PTFlanagan Daniel Thomas · Kent, WAN13SSSmith Sharon D · Deridder, LAN14101Weaver Clifford A · East Berlin, PAN1414MCruz Glenn A · Star, IDN1419MPierce Mark V · Havertown, PAN1420MMortenson John V · Arlington, VAN1423MPeters D R II · Laurel, MSN1431CJensen Aviation Inc · South Haven, MIN1434MEastern Stearman Inc Trustee · Leesburg, VAN143JSMcclain Aviation LLC · Roanoke, TXN145NPelton Jack J · Wichita, KSN146CMMartin James D · Leesburg, FLN149WAvakian Haig · Vineland, NJN14GCJr Stearman LLC · Fairfield, CAN1502MAtmore Flying Service Inc · Century, FLN1505M450 Stearman LLC · Southampton, NJN1522MRopkey Armor Museum Inc · Indianapolis, INN1535MLegacy Biplane LLC · Stanley, NCN1559MCarlton John B · Lenoir, NCN1560MPrice William B · Lamar, SCN159CBOtto Aviation Ltd · Newark, DEN15GCMartinez Juan R · Secaucus, NJN15LZZambrano Mario · Austin, TX
Back to AD 63-13-01