AD 99-05-13 R1 WD
Registered aircraft · 13,518
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:99-05-13-R1-WD')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
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:99-05-13-R1-WD') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD') 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.
N5739KLyn Alden Cleveland · Kansasville, WIN574Yunt David W · Springboro, OHN5741VSjr Properties LLC · Reno, NVN5742KCygnet Aerospace Corp · Los Osos, CAN5742VAllen Bruce C · Anna, TXN5745KGreen Mountain Avionics Inc · Middlebury, VTN5745VBonanza N5745v LLC · Colorado Springs, CON5747KDel Martin Lp · Spring, TXN5748VB55 Partners LLC · Vero Beach, FLFirst renewal noticeN5749KBase To Final LLC · Mesa, AZN574JPThompson Phillip · Lakeway, TXN574SBRj Group Investments LLC · Lawton, OKN574TMcallister Todd K · Grangeville, IDN5750KSamons David M · Phoenix, AZN5751KDetloff Martin P · Kaukauna, WIN5753KSale Reported · Fort Worth, TXSale reportedN5754VWeiser Steven Clark · Hutto, TXN5755KBrooks Auto Parts Inc · Douglas, GAN5755VArnold Alan Dale · Glenwood Springs, CON5758VNelson Mike R · Philip, SDN575GWNeuse Aviation LLC · Smithfield, NCN575NVSouthern Aircraft Consultancy Inc Trustee · Casper, WYN575SLPhipps Vaughn Pago · Chattanooga, TNN5762KBagwell Jason R · Garner, NCN5763KNnamsu Enterprises LLC · Walnut Creek, CAN5766VBruce James W · Searcy, ARN5768VSkyzure LLC · Chelsea, MIN5769KHepburn Jeffrey T · Atlanta, GAN5770KStevens Eugene E IV · Silver Spring, MDN5770VAkins Terral S · Grain Valley, MON5771VLow & Slow Aviation LLC · Westminster, CON5772VSouthwest Truck Parts Inc · Pratt, KSN5777KMayes Mark E · Bisbee, AZN5777VDe La Garza Jimmy · Granbury, TXN5778KSimpson Fredrick L · Olympia, WAN5778VGlenn Larry D · Reynoldsburg, OHN5779KHarris Aircraft Leasing Co · Oklahoma City, OKN577BKrueger Hendrik · Rockport, TXN577FCFlight Club · Middle River, MDN577KBDavid A Bush Inc · Hanford, CAN577UV & V LLC · Shenandoah, VAN57829Jrw Aviation Inc · Anchorage, AKN5782VDave Sheets And Sons Contracting Inc · Columbia City, INN5783KSullivan Peyton C · Alamogordo, NMN5784KN5784k LLC · Kalispell, MTN5786KRocket Investments LLC · Independence, MON5787VArends Jeffrey B · Brooklyn, CTN578UHawley Elizabeth · Wichita Falls, TXN5794VHand Timothy P · Osage Beach, MON5795VTech Specialty Services LLC · Killeen, TX
Back to AD 99-05-13 R1 WD