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.
N4450WVarnell Chad W · Dripping Springs, TXN445HSBas Part Sales LLC · Greeley, CON445JSAg Ranch Services LLC · Lewistown, MTN445KPHawaii Pacific Aviation Inc · Kailua Kona, HIN4465VGreen & Schweers Inc · Batesville, TXN4466Nordwald Aviation Services LLC · Mexico, MON446BBJb Buffalo LLC · Frisco, TXN446HSUS Department Of Agriculture · College Station, TXN446SGCedar Ridge Aviation LLC · Knox City, TXN446TCChena River Aviation Inc · Fairbanks, AKN4471JN4471j LLC · Dover, DEFirst renewal noticeN447BAHc01 LLC · Vero Beach, FLN447CFBleecker Lee M · Dousman, WIN447DD115 Holdings LLC · Mansura, LAN447MHKelsey Terry D · Guthrie, TXFirst renewal noticeN447PAPollux Aviation Ltd · Wasilla, AKN447PWCannon David A · Magnolia, TXN447RCEmerald City Aircraft Leasing Inc · Port Orchard, WAN447SEmerald City Aircraft Leasing Inc · Port Orchard, WAN4481GRotor Leasing LLC · Indianapolis, INN4482GRotor Leasing LLC · Indianapolis, INN448BASpitzer Helicopter LLC · Woodland Hills, CAN448DBC V C Holdings LLC · Pasco, WAN448SHNovember Alpha LLC · Los Angeles, CAN4493XStott Mark L · Fairbanks, AKN4497VMiller Kale Michael · Mountain Home, TXN4499Southern Utah University · Cedar City, UTN44997Faulkner 44 LLC · Wilmington, DEN449ASConcho Aviation LLC · Sterling City, TXN449BASpitzer Helicopter LLC · Woodland Hills, CAN449BCMcbride Richard A · Deer Park, WAFirst renewal noticeN449CD9 Robin LLC · Wilmington, DEN449CNSpeedo Air LLC · Hales Location, NHN449MSMs Aviation LLC · Los Angeles, CAN449RV T Whitlock Inc · Lake City, SCN44BPAircraft Partner Holdings Inc Trustee · BerlinN44DQTumbleweed Leasing Co Inc · Salt Lake City, UTN44EKBas Part Sales LLC · Greeley, CON44FEAirborne LLC · Wilmington, DEN44FGSaratoga Helicopter LLC · Queensbury, NYN44HDAir Assault Agricultural Aviation LLC · New Castle, VAFirst renewal noticeN44HFRobinson Helicopter Co · Torrance, CAN44HGHigher Ground Helicopters Of Cincinnati LLC · Miamisburg, OHN44HNCedar Ridge Aviation LLC · Knox City, TXN44JUEcho Mike Consulting LLC · Wilmington, DEN44KVHughes Eugene F Jr · Butte, MTN44KYBas Part Sales LLC · Greeley, CON44LNBrown Bear Air Inc · Anchorage, AKN44NHJanitz Thomas B · Indianapolis, INN44NQSky West Aviation Inc Trustee · Albuquerque, NM
Back to AD 95-26-05 R1