AD 72-16-09
Registered aircraft · 47
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:72-16-09')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-16-09')
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:72-16-09') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-16-09') 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.
N101SYRegistered aircraftN105UADown East Emergency Medicine Institute · Orono, MEN107BNBig Boy Toys LLC · Mars, PAN126SRDown East Emergency Medicine Institute · Orono, MEN12964Sunflower Aero Inc · Atwood, KSN138SRDown East Emergency Medicine Institute · Orono, MEN13SDSnohomish County Sheriffs Office · Snohomish, WAN142SCSpartanburg County Sheriffs Office · Spartanburg, SCN160DAWehring Justin DBA · Clute, TXN17167Slade Aviation LLC · Carlsbad, NMN174ECBingham Larry F · Juneau, AKN17801Mckee John R · Central Point, ORN187YMBrown Byron Tim · Hermiston, ORN2091RCity Of El Paso Police Department · El Paso, TXN21772N21772 LLC · Wellington, FLN259BKCavanaugh Collections Inc · Addison, TXN262SDCullman Police Department · Cullman, ALN278KCCullman Police Dept · Cullman, ALN298SDCsw LLC · Anacoco, LAN301SDHarrison County Sheriffs Department · Gulfport, MSN305AZJta Express Inc · Wilmington, DEN330CMDewind Helicopter Services LLC · Zeeland, MIN332ABUsda Aphis Ws Atoc · Cedar City, UTN369DRReynolds Darryl G · Wills Point, TXN369KECbft LLC · Mobile, ALN387RFMid America Flight Museum · Mount Pleasant, TXN41776Warbirds-3 LLC · Kalispell, MTN4337BBatto John H · Carson City, NVN47267Mckee John R · Central Point, ORN535XOxford Police Department · Oxford, ALN53HCDrive A Tank Inc · Kasota, MNN546Moore Lewis D Jr · Bear Creek, NCN56TWMckee John · Central Point, ORN58479Usda Aphis Ws Atoc · Cedar City, UTN6246WStarfire Aviation LLC · Renton, WAN6252FRoxbury John A Jr · Princeton, MNN658JLLauderdale Aeronautics LLC · Davie, FLN665SRDown East Emergency Medicine Institute · Orono, MEN818SCHartland Helicopters LLC · Edinburg, TXN888DXAlexander Mary · Grants Pass, ORN888USAm Air Service LLC · Green Oaks, ILN9010FCody Richard A · Mclean, VAN9117HBrown Helicopter Inc · Pensacola, FLN911HUUsda Aphis Ws Atoc · Cedar City, UTN911JXSt Louis County Police · Chesterfield, MON9792SGrand Haven Aviation Services · Spring Lake, MIN99888Combat Rotors LLC · Eugene, OR
Back to AD 72-16-09