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.
N442JEConcho Aviation LLC · Sterling City, TXN442JMStarr County Helicopter Services LLC · Mcallen, TXN442JPFix Wing LLC · Fort Lauderdale, FLN442KPUtah State University · Logan, UTN442KYSouthern Cubs LLC · Jupiter, FLN442MDMagill Zane · Castell, TXN442MGYeti Heli LLC · Westminster, MAN442MRSleigh Helicopter LLC · Palm City, FLN442PDDesoto Parish Sheriff Office · Mansfield, LAN442PPWilco Helicopters Inc · Oregon, ILN442PRA&E Aerial LLC · Texarkana, TXN442PWBeluga LLC · Wasilla, AKN442RDThompson Helicopters LLC · Uvalde, TXN442RNPope Jim D · Lewiston, IDN442RTRm Capital Holdings LLC · Hockessin, DEN442RYParagon Helicopter Services LLC · Claremore, OKN442SDTeam Negrich LLC · Osteen, FLN442SHRudd Wayne G · Basalt, CON442THUtah State University · Logan, UTN442TSLehman Aviation LLC · Winamac, INN442UKSpitzer Helicopter LLC · Woodland Hills, CAN442VBHicks Seal Coating & Striping LLC · Bell, FLN442WMElkhorn Aviation Inc DBA · Baker City, ORN4439ULee Robert A · Hartford, WIN443AS443 Alpha Sierra LLC · Tulsa, OKN443DCSouthern Aircraft Consultancy Inc Trustee · Casper, WYN443DRDakota Rotors LLC · Custer, SDN443HHHermens Stanley G · Wallowa, ORFirst renewal noticeN443LCBlack Beauty Helicopters LLC · Davie, FLN443MMEarlybird Aerial Services LLC · Goodfield, ILN443RPRichard E Pierson Construction Co · Pilesgrove, NJN443RSNtss LLC · Las Vegas, NVN443SANovember Alpha LLC · Los Angeles, CAN4447ASouth Texas Helicopter Services LLC · Mcallen, TXN4447VTurkey Holler LLC · Shamrock, TXN444AJAj2 Air LLC · Arroyo Grande, CAN444BUHelifun Expeditions LLC · Kalispell, MTN444BWAmigo Helicopter Services LLC · Falfurrias, TXN444CJAms Company Inc · Cleburne, TXN444DVSky High Helicopters LLC · Camarillo, CAN444HGHigher Ground Helicopters Of Cincinnati LLC · Miamisburg, OHN444HHAircraft Management Group Intl Corp Trustee · Wilmington, DEN444JYSchwarzenberg Johannes · Helena, MTN444MLBarrett James P · Calistoga, CAN444NCCharlie Papa LLC · Van Nuys, CAN444NWRegistration Pending · Mill Creek, WARegistration pendingN444RHHelisafe Inc · Long Beach, CAN444SKSpitzer Helicopter LLC · Woodland Hills, CAN444UHAlba Aviation Services Inc · Scottsdale, AZN444VHMf Helicopters LLC · East Troy, WI
Back to AD 95-26-05 R1