AD 75-06-01
Registered aircraft · 2,832
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-06-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-06-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-06-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-06-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.
N208YYAircraft Structures International Corp · Enid, OKN208ZZSpeedstar Express LLC · Carson City, NVN209STSky West Aviation Inc Trustee · Albuquerque, NMN20AEButler Aviation Inc · Houma, LAN20FDGilmer Aircraft Leasing LLC · Wilmington, DEN20KAAltair Advanced Industries Inc · Bellingham, WAN210BTGood Aviation LLC · Oshkosh, WIN210VACommonwealth Of Virginia · North Chesterfield, VAN2111TMccool Air Service Inc · Mc Cool Junction, NEN211CRRegistered aircraftN211GLAlpine Aviation Inc · Provo, UTN211MAvp Aviation LLC · Indianapolis, INN2126TTidwell Sprayers Inc · Dimmitt, TXN212DTThiel Aircare Inc · Chowchilla, CAN212HBBritt Christopher Charles · Bryan, TXN212HPCorpat Inc · Missoula, MTN212LWPf Aviation LLC · Carl Junction, MON212PKOc Aviation LLC · Victoria, TXN212YS76b LLC · New York, NYN213DBMarshall Air Systems Inc · Charlotte, NCN213MCMcr Aviation LLC · Austin, TXN213REWhital Enterprises LLC · Dover, DEN214GBPterodactyl Inc · Wilmington, DEN214NXLife Flight Network LLC · Aurora, ORN214PNavajo Nation · Window Rock, AZN214SCAzul Air LLC · Dover, DEN215SDEastern Stearman Inc Trustee · Leesburg, VAN216CSAlpine Aviation Inc · Provo, UTN216KQState Of Washington · Olympia, WAN216PKTecumseh Skydiving School LLC · Jackson, MIN217EBRapids Camp Lodge Inc · King Salmon, AKFirst renewal noticeN2185MFreefall Express · Gardiner, NYN218PAPreferred Airparts LLC · Kidron, OHN219WWTj Air Holdings Inc Trustee · Wilmington, DEN21AUBoeing Co · Renton, WAN21FGCalifornia Department Of Fish And Game · Sacramento, CAN220GLAlpine Aviation Inc · Provo, UTN220MARegistration Pending · Chestertown, MDRegistration pendingN220QKBridger Aviation Services LLC · Belgrade, MTN220TTShannair LLC · Saint Louis, MON220UM3k Aviation LLC · Birmingham, MIN221BHUas Transervices Inc · Boca Raton, FLN221BNSkyhi Aero LLC · Jasper, TNN221GSendero Aviation Services LLC · Dublin, TXN221JDPerrydise Aviation LLC · Tulsa, OKN222CMBriar Lakes Productions Inc · Palestine, TXN222CYBlue Star Gas Fleet Services Co · Santa Rosa, CAN222HHJenntoo LLC · Wilmington, DEN222PVJ Turbines Inc · Wilmington, DEN222RLTalon Air Service Inc · Soldotna, AK
Back to AD 75-06-01