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.
N16KWWild Blue Aviation LLC · Wilmington, DEN16TBEager Beaver LLC · San Diego, CAN16TMTriad Physician Resources Inc · Longview, TXN170GLAlpine Aviation Inc · Provo, UTN170JCWlgb200 LLC · Reno, NVN171CJBering Air Inc · Nome, AKN171GCRigidworks LLC · Anaconda, MTN171SCotterkey N171s LLC · Phoenix, AZN173KSCentralav LLC · Lake Worth, FLN175LAMitchell Andrew D Trustee · Winnie, TXN175SAGeneral Atomics · San Diego, CAN175WBHerdair Group LLC · Conroe, TXN176YVHill Air Executive Inc · Fort Pierce, FLN177CNRca Aviation 2 LLC · Tempe, AZN177LACabeza De Vaca Holdings LLC · Carrollton, TXN177RAUnited States Government · Fort Belvoir, VAN178GCRigidworks LLC · Anaconda, MTN178YVAlpine Aviation Inc · Provo, UTN179MDGem City Properties LLC · Laramie, WYN179SAPriority Air Charter LLC · Kidron, OHN17CKAgape Flights Inc · Venice, FLN17KKRiverbend Aviation LLC · Hernando, MSN17LHHigh Flying Investments LLC · Texarkana, ARN17PASailfin Partners LLC · Southfield, MIN17YLYowell Legacy Aviation LLC · Killeen, TXN180AVAdams Aviation Services Inc Trustee · Wilmington, DEN180MRState Of Maine Dept Of Marine Resources · Augusta, MEN182KQSnl Aviation LLC · Seattle, WAN183SADriscoll David A · Savannah, TNN18471Chase Air LLC · Montgomery, ALN1848ST&T Air LLC · Lindsay, OKN184AEN184ae LLC · Ault, CON184UXAlpine Aviation Inc · Provo, UTN186DCAir Care Inc · Lamar, CON186PSRricko LLC · Portland, ORN187JDMacarthur Dougald F · Littleton, NHN187LALocker Fred · Muleshoe, TXN187MRJcs Air LLC · Auburn, ALN188CECruise Air LLC · Wilmington, DEN188DFArc Holdings LLC · Grand Junction, IAN189GCCortez Fisher LLC · Kirkland, WAN189PBBerryhill Aviation LLC · Atoka, TNN18AFN220pb LLC · Mesa, AZN18BTT5 Capital Partners LLC · Dallas, TXN18CMEdgewater Aviation LLC · Guntersville, ALFirst renewal noticeN18DSN18ds LLC · Mcminnville, ORN18MYWorld Aircraft Leasing Inc · Wilmington, DEFirst renewal noticeN18NTYr-Aircraft Leasing LLC · Bethel, AKN18SFD&D Maintenance LLC · Etna Green, INN18SRW4 Air LLC · Willis, TX
Back to AD 75-06-01