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.
N6876HSt Charles County Flying Club LLC · Portage Des Sioux, MON6877ASchenck Alan E · Clarinda, IAN6877EBell Connor C · Maple Valley, WAN6877HKoenig Ned · New Bremen, OHN6877XSwick Gerald K · Murfreesboro, TNN6878XLinkinhoker Craig W · Carpentersville, ILN6879EWilliams James W · Friendsville, TNN6879MCohen Robert · Buda, TXN6879XRegistration Pending · Farr West, UTRegistration pendingN687AZZublin John A III · Murrieta, CAN687BASvetfur Aviation LLC · Camden, SCN687CPCivil Air Patrol · Maxwell Afb, ALN687RTFvx Research · Greenville, DEN687SPBmg Aviation Inc · Bloomington, INN6880EBartel Anthony E Jr · Ridgecrest, CAN6880MKing Dale C · Simi Valley, CAN6881EInternational Air Services Inc Trustee · Carson City, NVN6881XWestmoreland Dennis F · Snyder, TXN6882FHernandez Kevin F · Redmond, ORN6883AOswego Joint Venture · Tchula, MSN6883GSchroeder David C · Norfolk, NEN6884HWings Over Texas Holdings LLC · Denton, TXN6884XBaked Industries Inc · Yuba City, CAFirst renewal noticeN6885EHeiser Reggie · Polson, MTN6885HRasmussen Stewart · Santa Barbara, CAN6886EHadley David C · Herriman, UTN6886HParr Larry · Clarksville, TNN6886MJohnson Bill J · Canton, GAN6887ABradshaw Gary E · Warfordsburg, PAN6887EPatton Martin O · North Ridgeville, OHN6887GMassuet Nancy O · Sunrise, FLN6888ESteinhausen Darrell · Torrington, WYN6888HN6888h LLC · Wayne, NJN6889GKozlowski James · Zeeland, MIN6889RShelton L Wayne · Rifle, CON6889XSchler Joseph B · Reno, NVN688AAAoa Kissimmee Inc · Kissimmee, FLN688CABetter Southlake Properties LLC · Pagosa Springs, CON688DDPropit Inc · Wilmington, DEN688DWRegistration Pending · Concord, NHRegistration pendingN688JFCrothers Travis · Madison, MSN688KTGlore Reilly P · Olympia, WAN688PAJoe P Fassio · Union, WAN688PGGo Blue Sky LLC · Trinity, TXN688WBaum Eldon L Jr · Wellsville, PAN6891EOakes Stephen · Joshua Tree, CAN6891FN6891f LLC · Woodruff, SCN6891HRegistration Pending · Uvalde, TXRegistration pendingN6892FDent Kelly J · Locust Grove, GAN6892GDetroit Public Schools Community District · Detroit, MI
Back to AD 79-10-14 R1