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.
N6905DEvans Theresa K · Alexandria, MNN6906KWilliams Don D · Athens, ALN6907BJordan Walter B · Chehalis, WAN6908KRegistration Pending · Dillingham, AKRegistration pendingN6909BKaufmann Arnold L · Davenport, IAN6909KJersey Devil Dusters LLC · Southampton, NJN6910DWood Robert A · Sheboygan, WIN6911KHatley Sean P · Mount Horeb, WIN6913Cooper Steven J · Redwood City, CAN6913BKeyt Jeffrey D · New Providence, NJN6913KMedcroft Sean M · Edmonds, WAN6914BLark Bradley J · Enoch, UTN6916KBrown Daniel A · Gettysburg, PAN6918Sutherland Robert · Bowling Green, KYN6919BPolyclinics.Net LLC · Hixson, TNN6921BKnepp Gerald L · Milroy, INN6923BWitzel John F Jr · Frenchglen, ORN6923DCline Patrick G · Granbury, TXN6923KLeocha Anthony J · Hampstead, NHN6926DGibson Christopher R · Natchez, MSN6926KRed Wolf Aviation LLC · Venice, FLN6927KLord Mary E · Kalama, WAN6928DRegistration Pending · West Yellowstone, MTRegistration pendingN6929DJohnson Timothy D · Chapel Hill, NCN6931DThomas Isaac F · Portland, ORN6931KValiair Limited Co Trustee · Casper, WYN6932BHauser Nathan · Newark, DEN6932KHodge Tyler · Prattville, ALN6933DRegistered aircraftN6934BBrownlee Chase J · Billings, MTN6934DJohnson Steven D · Pardeeville, WIN6936KVan Bergeyk Ronald J · Trapper Creek, AKN6936ZKingsley Kiman J · Miller, MON6937KInternational Air Services Inc Trustee · Carson City, NVN6937ZStewarts Aircraft Service Inc · Waynesville, OHN6938DVanaman Robbie M · Wheeling, WVN6938ZWerth Lance C · Johnson Lake, NEN693JBScott Alia T · Wasilla, AKN6940BRegistered aircraftN6941DKodysh Peter J · North Ridgeville, OHN6941KWinter Gary L · Ocala, FLN6942DHorwitz Kenneth D · Bremerton, WAN6942KGold Cap LLC · Bremerton, WAN6942YVan Fossen Eddie L · Bakersfield, CAN6943BAndrews Joshua T · Lakeview, ORN6943KLow And Slow Aviation LLC · Williston, FLN6947BB&R Aerial Crop Care Inc · Connell, WAN6948KTerch Lawrence P Jr · North Pole, AKN6949BPool Gene E · Anchorage, AKN6949KSaverio Gambassi · Bealeton, VA
Back to AD 99-01-05 R1