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.
N426CTAir Kraft Aviation LLC · Timber Lake, SDN426JKHuku 2 LLC · Princeton, NJN427AFExecutive Jet A LLC · Danbury, CTN427DTEagle Eye Helicopter LLC · Fort Pierce, FLN427RAHilty Benjamin D · South Boston, VAN428JGDr Rotors LLC · Mccall, IDN429AFConcho Aviation LLC · Sterling City, TXN42FTVentana Blue LLC · Hyattville, WYN42GAGuidance Helicopters Inc · Prescott, AZN42LFSodville Inc · Taft, TXN42VBHeli Ag LLC · Waller, TXN430AFAir First LLC · Kalispell, MTN430DERotorwing LLC · Sheffield, ILN430LRLee Aviation Services LLC · Wilson, NCN4312GGruben Donald C Jr · Rotan, TXN432BRBakken Rotors LLC · Sidney, MTN432LCCardinal Roots LLC · Middletown, DEN432PCRace Scott Ritchie · Odessa, TXN433DEIndependent Helicopters LLC · New Windsor, NYN433LMRoss Richard R · Mckinney, TXN433SKRycoe Air LLC · Auburn, NYN433TBTriangle Aviation LLC · Minonk, ILN434AJAce Flight LLC · Houma, LAN434DESpitzer Helicopter LLC · Woodland Hills, CAN434DVClassic Management Of Lafayette LLC · Youngsville, LAN435DEThunderbird Aero LLC · Mertzon, TXN4361RElkhorn Aviation Inc · Baker City, ORN436AFAg Ranch Services LLC · Lewistown, MTN436DERowe John · Kansas City, MON436MRCedar Ridge Aviation LLC · Knox City, TXN4377UTalkeetna Air Taxi Inc · Talkeetna, AKN4377XDk Air LLC · Brookings, ORN437DETumbleweed Leasing Co Inc · Salt Lake City, UTN437LMGigliotti Darin · Pueblo, CON4386WConcho Aviation LLC · Sterling City, TXN438DEAirduce LLC · Cheriton, VAN4392WLee John D · Hartford, WIN4395DWhirl'D Helicopters Inc · Sevierville, TNN439HPWanchese LLC · Marathon, FLN439LLHolseberg Aviation LLC · Ridgeville, SCN43ALFloyd Air LLC · Searcy, ARN43GACrosswind Leasing LLC · Prescott, AZN440AKStrauss Craig R · Hicksville, NYN440BPBreeze Scott W · Thompsons, TXN440DKCitation Companeros LLC · Seguin, TXN440DRDakota Rotors LLC · Custer, SDN440DZSouthern Aircraft Consultancy Inc Trustee · Casper, WYN440EJJsj Aviation LLC · Mesa, AZN440KBJ3 Contracting Inc · Milton Freewater, ORN440RHAirtrust LLC - 12 - Series 12 Trustee · Sheridan, WY
Back to AD 95-26-05 R1