AD 85-02-05 R1
Registered aircraft · 8,920
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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.
N1465ALarsen Caesar S · Pleasanton, CAN1469AJohnson Steven C · Cheyenne, WYN146PWilliams Mike C · Sonora, TXN1471AJames Norris J · Kannapolis, NCN1472ASmith Wesley P · Donnelly, IDN1474ARichard Waldren LLC · Newberg, ORN1474PMccormick Robert E · Selah, WAN1478ABehr Casper J · Neavitt, MDN1479AOlson Phillip Francis · Tenino, WAN147ECAarow Aircraft Leasing LLC · Mcminnville, ORN1480CJohnson Mark A · Thousand Oaks, CAN1481AViseur Michael E · Tulsa, OKN1482CKnutsen Wayne R · Thompson, NDN148SBGriner Warren D · Pinson, ALN148TTBoard Of Trustees Western Michigan University · Battle Creek, MIN1491ASale Reported · Lone Jack, MOSale reportedN1492AKessler David Keith · Mineral Wells, TXN14934Csc Delaware Trust Co Owner Trustee · Wilmington, DEN1494AHelton Tom H · Santa Ana, CAN1495ARamos Benjamin · Yuma, AZN1497ASlagle Steven D · Auburn, WAN1498ASpivey Larry B · Milledgeville, GAN149PCSubick Leonard · Spring City, PAN14FCJwc59 LLC · Newnan, GAN14GSKerner Robert · La Vergne, TNN14YPHubbard Scott Edward Jr · Deatsville, ALN1501ASchaus Richard M · Schoolcraft, MIN1502AInternational Air Services Inc Trustee · Carson City, NVN1502PCarey Daniel F · Long Beach, NYN1503PRegistered aircraftN1504AHise Kevin E · Rock Rapids, IAN1506PStevens John P · Hernando, FLN1507PWagner Rickey J · Stacy, MNN1508ARegistered aircraftN150KSSommers Stuart S · Newberg, ORN150PFParagon Flight Training Co · Fort Myers, FLN150PPBurghduff Aviation LLC · Ludlow, SDN1514AMatthews Byron Kim · Hooper, UTN1516ALampart Floyd R · Lake Clear, NYN1516PRichardson Sean W · Delta Junction, AKN1517ALong Doug J · Wolf Point, MTN1520ABush James R · Seattle, WAN1522AAbbe Thomas E · Wasilla, AKN1526ACrow Robert M · Trapper Creek, AKN1526PBailey Mark T · Yelm, WAN1528PMa Ha Co Aero Corp · Ridgeville, INN1533APearson Trevor · San Ysidro, CAN1533PHager John S · Big Island, VAN1534ADelta Charlie Aviation LLC · Glendale, AZN1535AHerve Keith E · North Pole, AK
Back to AD 85-02-05 R1