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.
N86TJSignal Hill Air LLC · Durham, NCN86TSCts Aviation LLC · Apex, NCN870DKFoth Air LLC · Onida, SDN871RAShapiro David · Homer, AKN877DRCline Air Services LLC · Ellensburg, WAN878BCBas Part Sales LLC · Greeley, CON878CBPollux Aviation Ltd · Wasilla, AKN878USGreen Aviation · Augusta, MEN878YEYankee Helicopters LLC · Plainville, CTN8791CHelipl LLC · Winter Garden, FLN879YEAltitude & Anchor LLC · Kalispell, MTN87AKDeckload Aviation LLC · Kodiak, AKN87HRLat 29 Aviation LLC · El Campo, TXN87MDKachemak Bay Flying Service Inc · Temple, TXN881KEPorter Equipment Holdings LLC · Magnolia, TXN882CEEdison Aviation LLC · Wilmington, DEN882GDCosta Helicopter Services LLC · Aventura, FLN883DFAerial Ag Services LLC · Hillsboro, TXN883PMSignature Management LLC · Richmond, KYN883WRSpitzer Helicopter LLC · Woodland Hills, CAN884WRGoonz LLC · Lebanon, TNN885LHNomad Aircraft Leasing And Sales LLC · Panama City Beach, FLN886JBRegistered aircraftN888HACm3 LLC · North Las Vegas, NVN888SNSkylands Air LLC · Port Orange, FLN888UHAlba Aviation Services Inc · Scottsdale, AZN888UULake Ozark Helicopters Inc · Lake Ozark, MON889BBRegistration Pending · Porter, TXRegistration pendingN889EHMillhouse Eric L · Cheyenne, WYN890MPAngel Air LLC · Boynton Beach, FLN8914PRomiewood Aerospace Fl LLC · Tampa, FLN891MPPalm Coast Aircraft LLC · Palm Coast, FLN892MPFly 'N Pancake LLC · Camden, DEN892SAShier Aviation Corp · San Diego, CAN8937RBeckett David · Wasilla, AKN893MPRegistered aircraftN893PRs Aviation Services · Moorpark, CAN893PCCline Air Services LLC · Ellensburg, WAN894MPRobinson Helicopter Co · Torrance, CAN896JUniversity Of North Dakota · Grand Forks, NDN896SMSeaton Flying Services · Killeen, TXN897SUSouthern Utah University · Cedar City, UTN898GBBoslough Construction Inc · Anchorage, AKN899GSDead Eye LLC · Lewes, DEN899KSEurotec Vertical Flight Solutions LLC · Eudora, KSN899LRNovember Alpha LLC · Dover, DEN89RHGoodson John P · Newnan, GAN8YLHn Aviation LLC · Mooresville, NCN901TTEmerald City Aircraft Leasing Inc · Port Orchard, WAN901TVRotor Leasing LLC · Indianapolis, IN
Back to AD 95-26-05 R1