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.
N5HRRay Tanner Motors Inc · Phoenix, AZFirst renewal noticeN5HVOppegard Nicholas D · Eagle River, AKN5JPWard Russell S · Kingman, AZN5JTTj Air Holdings Inc Trustee · Wilmington, DEN5LPMeeks Trevor · Vineburg, CAN5LQCollignon William A Jr · Muscle Shoals, ALN5LSE&K Aero LLC · Friendswood, TXN5PCKeck Kevin W Trustee · Meridian, IDN5PTMunson George R · Westhampton, MAN5QUnusual Attitudes LLC · Thomas, OKN5RBBanasik Associates Inc · Columbus, OHN5RWToms Ronald C · Lena, LAN5RZBbz Consulting LLC · Cody, WYN5SCGarrett John R II · Waxhaw, NCN5SUFlorida Skymaster LLC · Cape Coral, FLN5VAVirginia Department Of Aviation · Richmond, VAN5VEMurphee Koby T · Spirit Lake, IDN5YXRed Arrow Aviation LLC · Santa Teresa, NMN5ZBBlue Aviation Inc · Venice, FLFirst renewal noticeN5ZXPush Pull LLC · Lewes, DEN5ZZLeirer Von O · Los Gatos, CAN60002Kirmeyer Dana L · Calhoun City, MSN6000ARichards John M · Oregon City, ORN6000LDoherty Douglas E · Nome, AKN6000RKreisler Curt A · Plantation, FLN6000VTextron Aviation Inc · Wichita, KSN60016Meassick Steven F · Mount Horeb, WIN60018Moreno & Nelson Construction Corp · Walla Walla, WAN6001GN6001g LLC · Wheeling, ILN6001JBullard Daniel C · Dallas, TXN60024Esker William D · White Mtn Lk, AZN60026Lareaux Jon R · Calumet, MIN60028Mesner Steven M · Tomah, WIN6002BWard William O · Pocatello, IDN6002JSeibert John E · Anchorage, AKN6002RZelner Gregory M · Merritt Island, FLN6003260032 LLC · Jackson, MIN6003BHenley Alan · Hoover, ALN60040Registration Pending · Cottage Grove, MNRegistration pendingN6004GLiberty University Aviation Dept · Lynchburg, VAN6004RSeaplanes R Fun Inc · Wilmington, DEN6004TIrwin Donald L · Emporia, KSN60050Elsen Paul D · Winnebago, ILN60051Compass Rose Aviation LLC · Derby, KSN60052Onofre- Trejo Ray · Chicago, ILN60053Textron Aviation Inc · Wichita, KSN60056Jones Edward · Mechanicsburg, PAN6005AClark Lewis R Trustee · Lansing, MIN6005BConnected Air LLC · Danvers, MAN6005GCrockett Guy S · Louisville, KY
Back to AD 79-10-14 R1