AD 78-26-10 R1
Registered aircraft · 142
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:78-26-10-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:78-26-10-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:78-26-10-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:78-26-10-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.
N6053LHenson Randolph C · Spring, TXN6054LTriple-R-Biplane Inc · Andover, NJN6075LChandler Air Service Inc · Chandler, AZN60GLMiko Pawel Marcin · Santee, CAN6185LKanaster Larry D Trustee · Tacoma, WAN6196LFiala Frederick P · Kingwood, TXN6197LRanger Airfield Foundation · Ranger, TXN6199LBoddy Derrick M · Aiken, SCN621GLOverwatch Tools Inc · Chesapeake, VAN6247LChandler Air Service Inc · Chandler, AZN6262LGreat Lakes Aircraft LLC · Palmer Lake, CON703GLTimblin Joel R · Boyceville, WIN707GLVoler Dans La Gloire LLC · Narberth, PAN707RMWilkes Jack M · Port Orchard, WAN711PTTaylor Stephen N · Punta Gorda, FLN727KRRogers Ronald J · Crystal Lake, ILN728GLMartin James D · Graford, TXN748LLdz Aviation Resources LLC · Sayville, NYN763GLUzyn Jerry J · Lafayette, INN765GLCroll H Robert III · Jacksonville, ORN76GLSullivan Vincent E · Centerville, IAN771VYGarcia Pedro · Hudson, OHN780ZAGreat Lakes Belle LLC · Furlong, PAN789JFCoordinated Turn LLC · Fort Worth, TXN78JRFocus Air LLC · Wilmington, DEN791BKBoucher Robert Nc · The Plains, VAN799DBTreetop Flyer LLC · Crozet, VAN79GLJones Robert B · Fresno, CAN802GLGiles Forrest D · Springtown, TXN80AMGreat Lakes Aircraft LLC · Palmer Lake, CON80JVBaker Aviation Consulting LLC · Summerland Key, FLN827GLEtchart Joseph O · Glasgow, MTN85GLAviation Insurance Managers Inc · Uniontown, OHN86WSPlane Fun Inc Tr Trustee · Snellville, GAN87GBertacchi Lawrence · Vineland, NJN87GLPendleton Terry S · Salisbury, NCN882BKRegistered aircraftN95HCCrosswell Joe · Springtown, TXN97GLHarrison Christopher J · Danville, CAN997WTRxy LLC · Gilbert, AZN99GLCristy Daron James · La Jolla, CAN9GLCampbell Joseph P · Vail, AZ
Back to AD 78-26-10 R1