AD 99-01-05 R1
Registered aircraft · 10,639
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-01-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:99-01-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:99-01-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:99-01-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.
N7086BHebert Wesley · Everett, WAN7087DRecknagel Martin D · Delta Junction, AKN7087ZCochrane Aaron W · Lake Bronson, MNN7088BParker John J · Monroe, ORN70897International Air Services Inc Trustee · Carson City, NVN7089BPurkinje Ltd LLC · Wilmington, DEN7089KMz Aviation LLC · Mason, OHN7089ZAzskyad LLC · Avondale, AZN7090KUlibarri Christopher G · Abilene, TXN7090ZSales Joe H · Seminole, TXN70914Schumacher Bradley R · Elma, NYN7092ZHollister Soaring Center LLC · Hollister, CAN7093BBackcountry Aviation LLC · Berthoud, COFirst renewal noticeN7093KMoyers Tommy E · Portland, ARN7093ZMid Continent Aircraft Corp · Hayti, MON70940Payne Ronald J II · Wasilla, AKN7094DPotter Kent · Laurel, MTN7096DPolecat Bottoms LLC · Jenks, OKN7098KHensley Roger A · Rosamond, CAN7099KLach Richard · Weldon, CAN7099YSparks Richard A · Wasilla, AKN70BTBurg Robert L · Fairbanks, AKN70LMIrving Mark S · Cordova, AKN71014Hofmann John M · Columbus, WIN7106BSlaughter D Wayne · Farmsville, NCN7106DHarris & Associates Inc · Scottsdale, AZN7106KClark Patrick C · Charlotte, NCN7108DWestern Antique Aeroplane & Automobile Museum · Hood River, ORN7108HLindsey Roy W · Quinlan, TXN7109BEastin Toby M · Jefferson City, MON7109KSheffield Vana Riggs Executrix · Amarillo, TXN7110BSeven-Eleven Brick Inc · Dalton, MNN7111DKeyt Jeffrey D · New Providence, NJN7112KHamann Hunter R · Spokane, WAN7112MHardy Russell E · North Pole, AKN7113DN7113d LLC · Ardmore, OKN7113KSavland Andy M · Hoonah, AKN7114BShore Brian R · Carmichael, CAN7114DPierce Brian L · Grants Pass, ORN7114ZSchwend Brian · Forsyth, MTN7115KHuseby Terry L · Hulett, WYN7116DSeelinger Donald P · Seldovia, AKN7117BSale Reported · Chelsea, MISale reportedN7117KKlutsch Joseph R · King Salmon, AKN7119BDelaney Patrick J · Marion, TXN711CSHodack Steven J · Burton, MIN711TSStarr William E · Eagle River, AKN7120DWeiss James R · Westlake, OHN7121DBohrman Robert C · New Berlin, WIN7121PLecren Douglas · Wasilla, AK
Back to AD 99-01-05 R1