AD 46-24-01
Registered aircraft · 1,529
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:46-24-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:46-24-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:46-24-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:46-24-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.
N1342MSkys Unlymited Inc · Wilmington, DEN1343MMehrer Fritz J · Oceanside, CAN1344MJohnson Lawrence F · Colville, WAFirst renewal noticeN1344VPlane Fun Inc Tr (Trustee) · Snellville, GAN1347VHolder James C · Leonard, TXN1357NGibbs 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, MIN13SSSmith Sharon D · Deridder, LAN14101Weaver Clifford A · East Berlin, PAN1414MCruz Glenn A · Star, IDN1423MPeters 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, CAN1522MRopkey Armor Museum Inc · Indianapolis, INN1559MCarlton John B · Lenoir, NCN1560MPrice William B · Lamar, SCN15GCMartinez Juan R · Secaucus, NJN15LZZambrano Mario · Austin, TXN1612MJohnson Jeffrey · Sanger, TXN1617MAmerican Airpower Heritage Flying Museum · Dallas, TXN161SBMak Ventures LLC · Morriston, FLN1626MOgr Air LLC · Erwinna, PAN1631MAmerican Airpower Heritage Flying Museum · Dallas, TXN1634MJohnson James K Jr · Sandy Valley, NVN1636MAshley James M · Greenwood, SCN1640MStas Stefan J · Clifford, PAN1658MHill George R · Carriere, MSN16BPN16bp LLC · Mesa, AZN16CCWhitney Frederick C · Hampton, NJN16PEAircraft Partner Holdings Inc Trustee · BerlinN16SDS Dacy Enterprises Inc · Harvard, ILN16XMid Continent Aircraft Corp · Hayti, MON1702MSouth Delta Aviation LLC · Grace, MSN1704MPlane Fun Inc Tr Trustee · Snellville, GA
Back to AD 46-24-01