AD 75-06-02
Registered aircraft · 78
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-02')
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-02')
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-02') 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-02') 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.
N77YVSara Helicopters Inc · Wilmington, DEN7UMSabe Aviation Inc · Santa Monica, CAN822LJCaribe Helicopters Inc · Coral Gables, FLN8305FDel Rio Aviation Inc · Paso Robles, CAN8345FAisling Developments LLC DBA · Calhoun, GAN8388FUsda Aphis Ws Atoc · Cedar City, UTN865HSRoyal Helicopter Services LLC · Exeter, CAN9016FHigh Shines Inc · Earl Park, INN9020FSideline Services LLC · Pearland, TXN9034FStuart Aviation Inc · Wilmington, DEN9052FMotivated Air LLC · Felton, DEN9107FUp Rite Aviation LLC · Zeeland, MIN9113QSea Corp Helicopters Inc · Wilmington, DEN9118FCook Jeffrey G Trustee · Ventura, CAN9132FHorizon Aviation LLC · Glastonbury, CTN9146FBerling Robert E · Mooresville, INN9166FNorthstar Marine LLC · Lewes, DEN9176F76f LLC · Calhoun, GAN9177FRotor View Inc · Wilmington, DEN9196FAsbill Jimmy T · Winnsboro, TXN9233FC & D Helicopters LLC · Spanish Fork, UTN9260FRjo LLC · Kenansville, FLN9267FManulwa Airways Inc · Hilo, HIN926ESRoyal Helicopter Services LLC · Exeter, CAN9677NDat Aircraft LLC · Lewes, DEN98369Diamond X LLC · Elko, NVN990SRBlue Penguin LLC · Lockhart, TXN9HAMiracle Robert B Sr · Perkasie, PA
Back to AD 75-06-02