AD 64-06-06
Registered aircraft · 4,740
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:64-06-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:64-06-06')
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:64-06-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:64-06-06') 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.
N15152Meyer Kendra · Ankeny, IAN15153Kyzer Stacey A · Fort Mill, SCN15159Piper One Five Niner Inc · Greenville, WIN15160Western Aire Flying Club Ltd · Sparta, WIN15171Eckler David L · New Hudson, MIN15176St Germain Joseph Ronald · Glenview, ILN15177Air Craft Enviromental Sys Inc · Hilton, NYN15190Coastal Air · Groton, CTN1519XAycd LLC · Allentown, PAN15200Cash Warren A · Loveland, CON15201Quaintance Kemper A · Culpeper, VAN15204Arthur Jeffery L · Lima, OHN15208Colorado Northwestern Community College · Rangely, CON1520TAaa Aero LLC · Glenwood, MNN15219Shoup Michael D · Pierre, SDN15223Dobson Anthony Eric · Alexandria, VAN15224Ludlow Reba J · Ponte Vedra Beach, FLN15227Plank James M · Sarasota, FLN15246Flightgest Academy LLC · Morrisville, NCN15247Flight Solutions Unlimited LLC · Bloomington, MNN15248Greer Daniel · Murrieta, CAN15251Thompson Roger C · Herndon, VAN15264Wrzesinski John B · Waxahachie, TXN15265M & P Aviation LLC · Franksville, WIN15266Plane Rents LLC · South Shore, SDN15274Matthews Francis J · Pagosa Springs, CON15277Flying Broom LLC · Prescott Valley, AZN15284Stevens Robert L · Ventura, CAN15291Plante Victor I · Maynard, MNN15299Dogra Gaurav · Madison, WIN15304Smeltzer And Sons Inc · Cape May C H, NJN15311Johnson Darin Charles · Wells, MNN15322Ofner Josef P · Canterbury, NHN15323Coastal Flight Inc · Tierra Verde, FLN1533XBurkhardt Stacie M · Wasilla, AKN15343Bridger'S Hvac And Welding LLC · Milan, TNN15354Stephen Swift · Justin, TXN15355Brandvold Larry J · Fairfield, MTN15358Daffer Jon T · Edgewood, NMN15361Williams Darren M · Carthage, ILN15363Creativity Before Capital LLC · Tampa, FLN15376Brown William D Jr · Mount Pleasant, TXN15377Johnson Matthew · Biglerville, PAN15378Ketcham Jesse E · Aguanga, CAN15391Lyon Anthony R · Bethesda, MDN15392Dgm Aviation LLC · Hurricane, WVN15396Nomann Arnold H · Viroqua, WIN15397Boisvert Thomas Michael · Sonoita, AZN154Nystrom Timothy L · Foreston, MNN15405Kurin Kerry · Tulsa, OK
Back to AD 64-06-06