AD 2017-15-05
Registered aircraft · 2,146
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:2017-15-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-15-05')
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:2017-15-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-15-05') 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.
N1188YSkylark Flight Training LLC · Panama City, FLN1189PParks Eric · Matthews, NCN118BLEdge Aviation LLC · Hawthorne, FLN1197PPenley Steven A · Corinth, TXN11KYKlad-Air LLC · Catlett, VAN11MPAtwill Brock · Paragould, ARN11MTSpeedy Aviation LLC · Liberty, SCN11PYCuller John T · Arvada, CON11PZCentral Virginia Flyers LLC · Palmyra, VAN11QTAv8rs LLC · Sugar Valley, GAN11TDDuflo Spray Chemical Inc · Lowville, NYN11YYAerospace Trust Management LLC Trustee · Wilmington, DEN1206APelham Aircraft LLC · Dallas, TXN1207PN73481 LLC · Ault, CON120DUnited States Air Force Owner · Hanscom Afb, MAN1210PRegistration Pending · Independence, MORegistration pending, pending cancellationN1215PTucker Robert B · Melba, IDFirst renewal noticeN1217Pendley Rory G · Torrance, CAN121SLLadet David E · Lavonia, GAN1220BWash Steven M · Austin, TXN122DDBeacon Hill Leasing LLC · Plymouth, MIN1231PTwin Oaks Airpark Inc · Hillsboro, ORN1234PThomas Steven E · Libertyville, ILN1236Entwistle Brian V · Knoxville, TNN123PJacobs Michael · Jay, OKN123PVSandlapper Aviation Of De Inc · Bennington, VTN1249VAguilar Perez Jose L · Newton, MAN1255PJones Jamie · Grants Pass, ORN12595Cornell Terry Jason · Bloomsburg, PAN125YDsr-Cherokee 180 LLC · Dallas, TXFirst renewal noticeN126MAWinter Kristin A · Spring Lake Park, MNN126PFPylant Ruth A · Lubbock, TXN1271PWendt Aero LLC · Newberg, ORN1273PMatthews Grover C · Fairborn, OHN128LBWareham Andrew John · Wasilla, AKN1292PEm Turbines Corp · Fort Lauderdale, FLN12FSLawley Frederick E · Bozeman, MTN12GEJ&P Master Flooring Corp · Lauderdale Lakes, FLN12JLGiber Kristofor D · Manvel, TXN12MPMarcus Robert L · Dallas, TXN1305PParkhill Clifton A Jr Trustee · Oxnard, CAN1308BHopewell Jeffrey D · Temple, TXN130MMMighty Mike LLC · Maysville, KYN1316PMatthews Grover C · Hardinsburg, KYN1317PWhite Christopher N · Clearwater, FLN1319PCanter Russell L · Enterprise, KSN131FAJones Donald T Jr · Barrigada, GUN131RMInternational Air Services Inc Trustee · Carson City, NVN131TVO'Brien Daniel H · Half Moon Bay, CAN132CTausch Roger M · Saint Charles, MI
Back to AD 2017-15-05