AD 75-22-03
Registered aircraft · 131
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-22-03')
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-22-03')
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-22-03') 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-22-03') 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.
N8388FUsda Aphis Ws Atoc · Cedar City, UTN865HSRoyal Helicopter Services LLC · Exeter, CAN888DXAlexander Mary · Grants Pass, ORN888USAm Air Service LLC · Green Oaks, ILN9010FCody Richard A · Mclean, VAN9016FHigh 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, DEN9117HBrown Helicopter Inc · Pensacola, FLN9118FCook Jeffrey G Trustee · Ventura, CAN911HUUsda Aphis Ws Atoc · Cedar City, UTN911JXSt Louis County Police · Chesterfield, MON9132FHorizon 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, DEN9792SGrand Haven Aviation Services · Spring Lake, MIN98369Diamond X LLC · Elko, NVN990SRBlue Penguin LLC · Lockhart, TXN99888Combat Rotors LLC · Eugene, ORN9HAMiracle Robert B Sr · Perkasie, PA
Back to AD 75-22-03