AD 87-20-03 R2
Registered aircraft · 54,015
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:87-20-03-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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.
N9522CToornburg Van W · College Grove, TNN9522HUrbas Robert M · Rockford, ILN9522LYellow Jacket Flying Club Inc · Atlanta, GAFirst renewal noticeN9522XNorthwoods Air LLC · Orono, MEN9523HVictor James A · Kingsville, OHN9524AHamel Ryan A · Klamath Falls, ORN9524BMeierotto Jeff T · Two Rivers, AKN9525XKuest Louis J · Anchorage, AKN9526BWildenberg Ronald · Beloit, WIN9526HAbove The Haze LLC · San Lorenzo, CAN9527MWhitetail LLC · Anchorage, AKN9527TTechnical Education Services Inc · Virginia Beach, VAN9528BNorris John R · Anchorage, AKN9528YHunt William R · Tucson, AZN9529CSilver Lining Carpet Care & Restoration LLC · Tallahassee, FLN9529TGarcia Richard E · Atwater, CAN952ASA2g International LLC · San Juan Capo, CAN952CBCentral Business Jets Inc · Burnsville, MNN952CCNewell Charles W · Naperville, ILN952RFArk Aviation LLC · Ladson, SCN9530BSierra Alpha Aeronautical LLC · San Antonio, TXN9530TNewby Harold A · Ramona, CAN9530XNelson Design & Engineering LLC · Portland, ORN9531ASpeirs Colin Jackson · San Luis Obispo, CAN9531BLash Trucking LLC · Goleta, CAN9531XMaclean James Shier III · Coppell, TXN9532ASchiller Darryl L · Belton, TXN9533APeterson Kristofor J · Talkeetna, AKN9533BWilson Thomas Henry III · Anchorage, AKN9533HPatnode Jeffrey W · Lewistown, MTN9533TWarren Roderick D · Hiawatha, KSN9533YN9533y Corp Trustee · Wilmington, DEN9534AWren James T · Gilbert, AZN9534BNissel James G · Saint Marys, PAN9534HBotezatu Florin · Gig Harbor, WAN9534TSale Reported · Spring, TXSale reportedN9534XCarlson Layne E · Twin Bridges, MTN9535HNorthwest Wings LLC · Hillsboro, ORN9535TGelner Ronald L · Pearland, TXN9535XBesties Properties LLC · Fergus Falls, MNN9535YSpectra Q LLC · Las Vegas, NVN9536HSampson Kelly J · Canby, ORN95374Board Of Trustees DBA · Murphysboro, ILN9537LPence Jeffrey S · Edinburg, VAN9537TSky West Aviation Inc Trustee · Albuquerque, NMN9538ASale Reported · Orlando, FLSale reportedN9538ENorthwoods Air LLC · Orono, MEN9538HK & L Air Inc · Brazil, INN9538XTodd Robert L · Alvarado, TXN95391Training Planes LLC · Tampa, FL
Back to AD 87-20-03 R2