AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N45281Stewart Patrick D · Reading, MIN45284Kelley Keith B · Forney, TXN45285Bennett Aaron K · Pulaski, VAN4528BHayton James B · Sedro Woolley, WAN4528CMcgough N C · Ferris, TXN4529CVandenbelt Kenneth J · Leslie, MIN452CPCivil Air Patrol · Montgomery, ALN452EPRainier Flight Service LLC · Renton, WAN452JSOffroad Aviation LLC · Las Vegas, NVN452KKramarich Kenneth · Wintersville, OHN452SMChristiansen Aviation LLC · Wilmington, DEN45302Missinne Brett R · South Range, WIN45308Berry Thomas F · Emmett, IDN4530BMichael Anna B · Daytona Beach, FLN4530CO Connor Mary B · Anchorage, AKN4530EAig Aeronautics LLC · San Juan, PRN4530FBean David L · Chandler, AZN4530UWorthington Gary · Swifton, ARN45312Heap Agriculture Service LLC · Stronghurst, ILN4531CGear N The Well LLC · Melbourne, FLN45327Cullen Richard J · Oshkosh, WIN45328N45328 LLC · Naples, FLN4532CHopkins Daniel E · Chandler, AZN45335Keeney Daphne C · Fairbanks, AKN45336Kelley Joshua S · Anchorage, AKN4533BHastie William B · Anchorage, AKN4533CBerwick Robert G · Sonoma, CAN45341Taylor Robert S · Satsuma, ALN45342Skybound Aviation LLC · Bixby, OKN45349Wall Johan D · Brookston, TXN4534BHornung Chet R · Nikiski, AKN4534E34 Echo Group · Spring Branch, TXN4534FSmith Peter A · Gunnison, CON45350Kelley Konrad E · Grant Valkaria, FLN45351Dallas Permian LLC · Mckinney, TXN45359Clapp Edwin G III · Fargo, NDN4535FRohde Allen G · Eagle River, AKN45361Price Gregory D · Frankfort, ILN45364Boren James Mason · Jasper, ALN45367Christensen Robert T · Presho, SDN45375Eastern Slope Aviation Academy · North Conway, NHN45376Jones Sharon J · Faulkton, SDFirst renewal noticeN4537BNewsom William A · Cheraw, SCN45385Steklenski Philip G · Olympia, WAN4538CSelby Gerald A · Sand Springs, OKN4538EGrasshopper Flying Club Inc · Poughkeepsie, NYN4538FLohse Teal K · Cordova, AKN45393Currie Grant · Hermosa Beach, CAN45395Holmgren Michael G · Kulm, NDN45398Tundra Wolf Inc · King Salmon, AKFirst renewal notice
Back to AD 79-10-14 R1