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.
N65192Tactical Integrated Training Solutions LLC · Colorado Springs, CON65195Sciortino Warren A III · Crested Butte, CON65197Aviator Education LLC · Greeley, CON6519ABreen Jerry P III · Center Point, TXN6519JDms Defense LLC · Annapolis, MDN6519MWarar Manjit S · Shreveport, LAN6519XN5746u LLC · Dover, DEN651DRCreative Art And Design LLC · Arvada, CON651ECEagle Sky Patrol Inc · Deadwood, SDN651EFGrizzly Air LLC · Clearwater, FLN651EREmbry-Riddle Aernautical University Inc · Prescott, AZN651MAPea-Wayman Flight LLC · Daytona Beach, FLN651PASmn Investments Inc · Greeneville, TNN651SPNew York State Police · Latham, NYN65206Brinkhoff Gary H · Hygiene, CON6520ENichols Matthew Q · Maple Valley, WAN6520SHighfield Carey · Vanceburg, KYN6520XKenton Onstad · Parshall, NDN652171434 Jpl LLC · Wilmington, DEN6521AWiplinger Robert D · Inver Grove, MNN6521DWaade Odd · Bellingham, WAN6521EWeaver Clifford A · East Berlin, PAN6521GKirk James H III · Odessa, FLN6521XNelson Scott W · Summerset, SDN65221Wings Over Texas Holdings LLC · Denton, TXN65225Leon Manuel Perez · Lake Worth, FLN6522AHubbard Robert L · Anchorage, AKN6522RKnot Ventures LLC · Kalispell, MTN6522SAlicandro Mark B · Sebastian, FLN65236Taylor Jonathan P · Danbury, CTN6523DAir Shares LLC · Casper, WYN6523ESkeen Andrew · Lindon, UTN6523FMatthews Mark · Brandon, MSN6523GLee Jay S · Granite Bay, CAN6523TVan Bavel Ethan G · Soldotna, AKN6523VReal Jonathan D · Kamuela, HIN6524DZuckerman Zvi A · Boardman, OHN6524EWhite Wings LLC · Anchorage, AKN6524GSantana Eric · Lehigh Acres, FLN6524HCole Keith D Trustee · Celina, TXN6524NWolcott Terri · Salem, ORN6524TParks Sam E Jr · Lytle, TXN652515280 Flying Club LLC · Castle Pines, CON65259Hillsboro Aero Academy LLC · Hillsboro, ORN6525DAerospace Testing Engineering & Certification Inc · Seattle, WAN6525MStene Nathanial S · Waterloo, NEN6526FHigh Exposure Inc · Wilmington, DEN6526MDapp Eric M · Corvallis, ORN6526THilt Destin R · Auburn, CAN6526VGoodrow Anthony F · Creede, CO
Back to AD 79-10-14 R1