AD 95-26-05 R1
Registered aircraft · 1,944
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:95-26-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-05-R1')
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:95-26-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-05-R1') 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.
N7047KSierra Sky Aviation LLC · Kalispell, MTN7048CMn Helicopters Inc · Minneapolis, MNN7049EGiraffe One LLC · Kalispell, MTN704TC & J Leasing LLC · Wasilla, AKN7052VOut Front Cc LLC · Kalispell, MTN7054LSchuh Roger J · Chowchilla, CAN70583Bult Equipment LLC · Monee, ILN7058VSpitzer Helicopter LLC · Wilmington, DEN7069XScout Aviation LLC · Odessa, TXN70727Vertical Corp · Kalispell, MTN7073TSky Helicopters Inc · Desoto, TXN7078YJes Storage Co · Wyoming, ILN7081MCollective Up Rmc LLC · Holiday, FLN7081NBrookway Aviation LLC · Brookhaven, MSN7083MCkz Ventures LLC · Anchorage, AKN7086LN43926 LLC · Dandridge, TNN7086YBp-Residential LLC · Addison, TXN7089GB-Squared Helicopters LLC · Daphne, ALN7089QJetko LLC · Boston, MAN708KSH G Reynolds Leasing LLC · Aiken, SCN7090JJk Air LLC · Cherryville, NCN70944Spitzer Helicopter LLC · Wilmington, DEN7094CEternity Helicopters LLC · Crestline, CAN7094JTtwn Media Networks LLC · New York, NYN7094LRedington Neal C DBA · Galena, ILN7095FSchrader Seth · Oklahoma City, OKN7098NSearcy Moto-Air Inc · Searcy, ARN70JPPayne Jon S Trustee · Santa Ynez, CAN70KAEmerald City Aircraft Leasing Inc · Port Orchard, WAN71010Axel Aviation Inc · Roswell, GAN7102ZRegistered aircraftN7103DSumner Properties LLC · Somersworth, NHN7106ZN7106z LLC · Chatsworth, CAN710BMRotor Aviation LLC · West Hartford, CTN710DYAirshare LLC · Anchorage, AKN710MYInterstate Helicopters Inc · Bethany, OKN7114RUniversity Of Alaska Anchorage · Anchorage, AKN7119UTtwn Media Networks LLC · New York, NYN712PCHolt Helicopters Inc · Uvalde, TXN712RBRonald Bauman LLC · Stuttgart, ARN7133EAir Assault Agricultural Aviation LLC · New Castle, VAN7138CDe Aviation LLC · South Wayne, WIN713PK536 Aviators LLC · Beaver, OKN715JLJll Aviation LLC · Front Royal, VAN715KFSpitzer Helicopter LLC · Wilmington, DEN715SGSilver Sky Helicopters LLC · Park City, UTN7162RPollux Aviation Ltd · Wasilla, AKN716JLTrack D LLC · Talkeetna, AKN717PZThompson Helicopters LLC · Uvalde, TXN7183CState Of Alaska · Anchorage, AK
Back to AD 95-26-05 R1