Registered aircraft · 620

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

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:78-26-04') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:78-26-04') ORDER BY n_number

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:78-26-04')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:78-26-04')
  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:78-26-04')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:78-26-04')
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.

N100ATWestern Pacific Fisheries · Hermosa Beach, CABuilt 1980 · S/N 500718D N101CHTri-State Vegetation Management LLC · Vevay, INS/N 1000829D N1020QMike Rinker Aircraft LLC · Union City, TNS/N 115-0426 N1020STactical Turtle LLC · Sheridan, WYBuilt 1966 · S/N 26-0467 N1020TSchroth Charles D · Gustavus, AKBuilt 1966 · S/N 56-0554 N1020ZBowar Gary R · Miranda, SDBuilt 1966 · S/N 66-0601 N102LUBlueskykai LLC · Wilmington, DEBuilt 1991 · S/N S1548 N102SUSignature Property Holdings LLC · Wilmington, DES/N 700736D N102WPGarcia Randy S · Montebello, CABuilt 1991 · S/N S1572 N10375Tactical Turtle LLC · Ortanna, PAS/N 67-18376 N1038NSome Beech LLC · Bolivar, MOS/N 85-0360 N104SUSignature Property Holdings LLC · Wilmington, DEBuilt 1977 · S/N 670151D N105ACAgricultural Air Services LLC · Jupiter, FLBuilt 1978 · S/N 580316D N105CMLewis Donn C · Millington, MIBuilt 1966 · S/N 66-0587 N105SUSignature Property Holdings LLC · Wilmington, DEBuilt 1988 · S/N 800776D N106KTDetgen Ernest J · Carmen, OKBuilt 1966 · S/N 46-0516 N106SUSignature Property Holdings LLC · Wilmington, DEBuilt 1981 · S/N 510954D N107SFDah Aircraft LLC · Georgetown, SCBuilt 1978 · S/N 1280405D N1088NTemsco Helicopters Inc · Ketchikan, AKBuilt 1980 · S/N 300679D N108ECHva Inc · Summersville, WVBuilt 1982 · S/N 811049D N108JSRamsey Ranch Aviation Inc · San Antonio, TXBuilt 1994 · S/N S1686 N1091PTemsco Helicopters Inc · Ketchikan, AKBuilt 1980 · S/N 300683D N1091STemsco Helicopters Inc · Ketchikan, AKBuilt 1980 · S/N 300691D N1092LDel Rio Aviation Inc · Paso Robles, CAS/N 410940D N1093YSchweizer Rsg LLC · Fort Worth, TXBuilt 1981 · S/N 411045 N1095TState Of Montana · Helena, MTS/N 800769D N1097JSignature Property Holdings LLC · Wilmington, DEBuilt 1980 · S/N 900801D N1098NDel Rio Aviation · Paso Robles, CABuilt 1981 · S/N 311038 N1101NLindemann Drilling Company Inc · Archer City, TXBuilt 1981 · S/N 510960D N1102DAviation Advantage Inc · Tabor City, NCBuilt 1980 · S/N 900806D N1103LAviation Advantage Inc · Tabor City, NCBuilt 1980 · S/N 1000812D N1103TDavis Rickey L · Weatherford, TXS/N 1100983 N1103VGulf Helicopters LLC · Santa Fe, TXS/N 1000823D N1104ZElectrical Systems Of Wy Inc · Gillette, WYBuilt 1980 · S/N 1000973 N11054Winco Inc · Aurora, ORBuilt 1981 · S/N 310910D N11056Northwest Helicopters I Inc · Olympia, WABuilt 1981 · S/N 310905D N1106GSenninger Thomas P · Clermont, FLBuilt 1981 · S/N 510955D N1106ZEnright Miles · Ketchikan, AKBuilt 1981 · S/N 210900D N1107NCairns Dave DBA · Lemon Cove, CABuilt 1981 · S/N 210902D N1107PTemsco Helicopters Inc · Ketchikan, AKBuilt 1981 · S/N 210897D N1107TAviation Advantage Inc · Tabor City, NCBuilt 1981 · S/N 210898D N1107VDarkstar Drones LLC · Brewton, ALBuilt 1981 · S/N 1201015 N11082Vertical Corp · Kalispell, MTBuilt 1980 · S/N 1100845D N110ESAirdale Helicopters LLC · Shawnee, OKS/N 58-0860 N1110QAviation Advantage Inc · Tabor City, NCBuilt 1981 · S/N 611011D N111ADSvp LLC · Missoula, MTBuilt 1980 · S/N 400704D N112ASOlympic Jet Inc · Olympia, WABuilt 1980 · S/N 900808D N1133CSara Helicopters Inc · Wilmington, DEBuilt 1974 · S/N 940636S N114HDWindward Aviation Inc · Puunene, HIBuilt 1978 · S/N 280261D N115ACRuhlman Dan C · Youngsville, PABuilt 1968 · S/N 580367

Back to AD 78-26-04