AD 46-49-01
Registered aircraft · 1,006
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-49-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-49-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-49-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-49-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.
N2747HGregory Vernon L · Swansea, SCN2749HEngle Elvin Michael · Houston, TXN2756HSoper Steven E · Rathdrum, IDN2757HEtchison Don L · Spring Hill, FLN2758HFitchpatrick Markel C · Blodgett, MON2766HBennett Bruce M · Louisburg, KSN2771HLambertson Paul C · Surprise, AZN2779JGregory Vernon L · Swansea, SCN2784HHudson Jason M · Toccoa, GAN2785HBal-Air LLC · Boca Raton, FLN2791HMoore James L · Humboldt, TNN2795HScholten Dirk J · Ames, IAN2797HWinters David D · Clarksville, TNN2800HGriggs Geri L · Kingsville, OHFirst renewal noticeN2806HKass John P · Apple Valley, MNN2808HBellomy Andrew · Hasty, CON2816HR & R Outfitters LLC · Kalispell, MTN2820HWelkner Brent G · Guyton, GAN2825HMayo Charles S · Woodlawn, TXN2829HMartin D East · Nicholasville, KYN2830HPowell Sherman B III · Pulaski, TNN2831HDon Jones Inc · Orange Beach, ALN2834HClausing Howard F · Menomonie, WIFirst renewal noticeN2837HNorberg John E · Eureka, CAN2844HSouthern Aircraft Consultancy Inc Trustee · Casper, WYN2845HGoff Frederick Myron · Vernon, CTN2849HCoupe Brothers LLC · Lopez Island, WAN2860HKerr Phillip D · Beebe, ARN2864HKarafit James T · Celina, OHN2865HBayne William R · Kaufman, TXFirst renewal noticeN2869HBeeman Robert P · Central City, PAN2872HBevelhymer Paul A · Grass Valley, CAN2875HBoley Richard J · Hayward, WIN2876HBurr Walter E II · Tecumseh, MIN2877HHeusdens Mark A · Kansasville, WIN2879HSmith Harry L · Leesburg, FLN2881HMickevicius Theodore A · Gregory, MIN2884HRogers Samuel I · Le Roy, KSN28921Newbury II Dennis M · Brea, CAN28928Tate Isaac · Yucaipa, CAN28932Williams Elden G · Redding, CAN28939Gregory Vernon L · Swansea, SCN28944Knox Raymond F · Clarksville, TNN28960Gregory Vernon L · Swansea, SCN28962Summit Aviation Holdings Of Nwa Inc · Rogers, ARN2902HFerguson Donald · Creston, OHN2904HBrecke Joshua Carl · Blossvale, NYN2906HZysko Jan A · Ocala, FLN2912HAnderas Per R · Green Bay, WIN2914HChipcraft LLC · Orlando, FL
Back to AD 46-49-01