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.
N4149XCyclic LLC · Kalispell, MTN4153GHeli Aviation Holding II LLC · Newark, DEN4154CSky Helicopters Inc · Garland, TXN4154GStuckey Shane A · Magnolia, TXN41584D Luckie LLC · Kalispell, MTN415RPRotorpro LLC · Sevierville, TNN4162MSilverhawk Aviation Academy LLC · Caldwell, IDN41631Submissive Air Inc · Deadwood, SDN4164QPollux Aviation Ltd · Wasilla, AKN416HHRotorwing LLC · Sheffield, ILN416LDLake Cumberland Helicopter Tours LLC · Monticello, KYN4174LCst & Sons LLC · South Barrington, ILN4175PAero Specialty Finance LLC · Chesterfield, MON4177GCedar Ridge Aviation LLC · Knox City, TXN4177MBrandl Farms LLC · Victoria, TXN4177RHangar 21 Aviation Inc · Lake Havasu City, AZN417PKFrancis David W · North Conway, NHN4181XFly For Fun Aircraft LLC · Rockville, MDN41842Robinson Helicopter Co · Torrance, CAN4186YCongdon Carl James · Manley Hot Springs, AKN418AFSkye Co LLC · South Williamson, KYN418TFSouthern Helicopters LLC · Vicksburg, MSN41BEVintage Aero Collection Inc · Wilmington, DEN41LYFedflyt LLC · Russell Springs, KYN41RHMile High Rotors Inc · Indian Hills, CON41VEJrvc Transportation Inc · Boston, MAN4203XNaples LLC · Mound City, MON4204WWilbourne Danny L · Melbourne, FLN4204XAircraft Equipment Storage LLC · Duson, LAN4210YDm Helicopters LLC · Pekin, NDN4213XAg Farmacy Applications LLC · Erie, ILN4214MLawler Helicopter Leasing LLC · Rochester, MIN4218KParker Helicopters Inc · Watsonville, CAN422DXMerten Aviation Services LLC · Holtville, CAN422FIntegrity Aircraft Title Holdings LLC · Portland, ORN422RXEmerald City Aircraft Leasing Inc · Port Orchard, WAN422TSFront Range Heli Inc · Erie, CON422WHAirman Helicopter Inc · Fort Lauderdale, FLN4230HHonolulu Helicopter Tours Inc · Honolulu, HIN4237XSpitzer Helicopter LLC · Woodland Hills, CAN4238HChandler Michael Shane · Texarkana, TXN423PMMen Aviation LLC · Foristell, MON4244MAir O Space LLC · Laporte, INN424CRS&S 1165 Investments · Wimberley, TXN424EPLuxury Helicopters Of South Florida Inc · Hollywood, FLN424SHLeading Edge Aviation Inc · Bend, ORFirst renewal noticeN4254GAlpine Air Aviation LLC · West Haven, UTN425RKQualitair LLC · MichelstadtN425RWQualitair LLC Trustee · MichelstadtN4269UAero380 Corp · Wilmington, DE
Back to AD 95-26-05 R1