AD 75-16-01
Registered aircraft · 17,795
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:75-16-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:75-16-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:75-16-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:75-16-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.
N106UMiha LLC · Dover, DEN1073MScr Aviation LLC · Austin, TXN1074CZata Group LLC · North Little Rock, ARN1074FNorth River Air LLC · Fairbanks, AKN1076FCavu Clearing LLC · Center Harbor, NHN1077ABabcock Mark E · Auburn, WAN1077FScileppi Gregory S · Sea Island, GAN1078FWilliams Casey D · Wasilla, AKN107JPPayne Thomas E · Old Forge, NYN107LHale Mitchell D · Chugiak, AKN107PFConant Dakotah · Ocala, FLN107SPDepartment Of Emergency Svc & Public Protection · Hartford, CTN107TYThornock Ty D · Shawano, WIN107WFWilcox Farms Inc · Roy, WAN1080MFlying Particles Inc · Livermore, CAN1082PGarrett James D Jr Trustee · Coolidge, AZN1083VWoltering Myron B · Granite Bay, CAN1084FSiktberg Timothy J · Nashville, TNFirst renewal noticeN1085MDuncan Terry C Trustee · Cupertino, CAN1086LLade Burton G · Bemidji, MNN1086MSargent John E · Vancouver, WAN1089FWells Thomas J · Big Lake, AKN1089MPetersen Clayton · Albert Lea, MNN108EENorthwood Services Inc · Skwentna, AKN108GWPope James D · Clarkston, WAN108PFKeith Wilcox & Sons Inc · Rexburg, IDN108SPDale County Sheriffs Office · Ozark, ALN1090MBergstrom Aircraft Inc · Pasco, WAN10948Morris Jacky D · Watonga, OKN1095FEggart Lawrence D · Nome, AKN10965Clampitt Darrell · Gray, GAN1099FSaal Christopher J · Anchorage, AKFirst renewal noticeN109CQWatkins Eric Brian · San Diego, CAN109RCLentfer Clinton H A · Anchorage, AKN109RSUnited States Department Of Interior · Boise, IDN109SWChugiak Aviation Leasing LLC · Chugiak, AKN109WYPerala Daniel R · Cheyenne, WYN109YBraun Joshua S · Port Hope, MIN10ARK Airmotive LLC · St Helens, ORN10AVMaak Holdings LLC · Missoula, MTN10DCHbk LLC · Lynden, WAN10GCBanks Keith Allen · Salisbury, MDN10HPAviation Systems And Service LLC · Mounds, OKN10JVHale Thomas O · Cotuit, MAN10KYMckinnon Laughlin Neil Trustee · Carlsbad, CAN10URXtiri LLC · St George, UTN10WQQuirion Paul J · Fairbanks, AKN1102GGlassy Water LLC · Brier, WAN1105XGay Faith E · Johnstown, NYN110FSMaggie L Air Service LLC · Kalispell, MT
Back to AD 75-16-01