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.
N463SKP5 Aviation LLC · Ephrata, WAN466WMDewey John L · Blackfoot, IDN467HABuell Travis · Harper, TXN469CBCentral Boiler Promotions Inc · Greenbush, MNN469TLSky Solutions LLC · Detroit, MIN46CHAltitude Aviation LLC · Wilmington, DEN46GACrosswind Leasing LLC · Prescott, AZN46GGSpitzer Helicopter LLC · Wilmington, DEN46TFHowell George Ryan · Conway, NCN4735HBrew F Robert · Valatie, NYN474LESky Photoshop LLC · Winter Garden, FLN474SHMeadowbrook Investments LLC · Cottage Grove, ORN475WHWidoff Howard Trustee · Eugene, ORN476JWWiggins Jason · Albany, GAN476NHHeadings Norman D · Walnut, ILN4783RFly In Helicopters LLC · Wilmington, DEN478ATAirmen Testing And Training Inc · Lantana, FLN47BDFlydreams Corp · Lewes, DEN47CFHover 32768 LLC · Kalispell, MTN4828HWilson Aviation Club LLC · Wilmington, DEN484ABCoejo Aviation LLC · Uvalde, TXN484AKUnited Therapeutics Corp · Silver Spring, MDN484ATHelicrop LLC · Menlo, IAN484SHNovember Alpha LLC · Dover, DEN484WBRegistration Pending · Kansas City, MORegistration pendingN485SLPlrg LLC · Wilmington, DEN486AKDeckload Aviation LLC · Kodiak, AKN488ACAustin Peay State University · Clarksville, TNN488JBSpitzer Helicopter LLC · Wilmington, DEN488KCPterofranc Flight Services LLC · Redding, CAN489GBNorthland Hangars LLC · Anchorage, AKN48CDSky Helicopters Inc · Desoto, TXN48WFEarlybird Aerial Services LLC · Goodfield, ILN48WMCalcaterra Paul · Okeechobee, FLN49007N49007 LLC · Wasilla, AKN4911XLake Superior Helicopters LLC · Duluth, MNN491SAShier Aviation Corp DBA · San Diego, CAN493RDEmdo LLC · Missoula, MTN4945FEmerald City Aircraft Leasing Inc · Port Orchard, WAN494SHIhde Investments Lp · Red Oak, TXN496DHeritage Air LLC · Anchorage, AKN497SUSouthern Utah University · Cedar City, UTN499LCLimocopter LLC · Orlando, FLN49CNVenture Air LLC · Leonard, NDN4QEQe Air Inc · Naples, FLN4QHTalkeetna Air Taxi Inc · Talkeetna, AKN5002YGlobal Aviation Florida LLC · Pompano Beach, FLN5010ADickson Roger · Saint Helena, CAN5011TAv8 Holdings LLC · Wilmington, DEN5011WSky Helicopters Inc · Desoto, TX
Back to AD 95-26-05 R1