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.
N9978HBrumette Aviation LLC · Vidalia, GAN9978NFulwiler Air LLC · Green Bay, WIN9978XLyons Jeffery E · Carrollton, GAN9979Dubois County Airport Authority · Huntingburg, INN9979B79bravo Leasing LLC · Lincoln, DEN9979CVan Lehn Sethany A · Frederick, MDN9979EFitzgerald Brett · Wellsville, UTN9979GSteinke Matthew R · Gibson, IAN9979NAvtech Global LLC · Renton, WAN9979TRoth Ellen C · Blakely Island, WAN9979XGeorge Anthony L · Billings, MTN997AKLake Clark Air Inc · Port Alsworth, AKN997CHHolly Ridge Planting · Indianola, MSN997JBBrannan Brendon Kyle · Gardnerville, NVN997PCHunter Marty Paul · Christine, TXFirst renewal noticeN997RRegistered aircraftN997SEAero Equities LLC · Ventura, CAN997TXPeso Consulting LLC · Lexington, TXN9980AYork Robert L · Capitan, NMN9980BBudenbender Philip W · Weatherford, TXN9980ERapid Flyers LLC · Zionsville, INN9980GSchwend Brian · Forsyth, MTN9981NGagnon Matthew I · Fairbanks, AKN9981VWeeks Richard F Jr · Portsmouth, NHFirst renewal noticeN99826Cp Aviation · Santa Paula, CAN9982TAero Club Albatross · Blairstown, NJN9982YChin-Loy Christopher Wayne Trustee · Tamarac, FLN99832Watch Ya Head Aviation 1 LLC · Zionsville, INN9983BMartyn Michael L · Ridgecrest, CAN9983HVisual Group LLC · Ringgold, GAN9983MTate Clint · Boise, IDN9983RHellmann Andrew P · Newark Valley, NYN9983TPara-Plane Aviation Inc · Thomasboro, ILN9983VHeyman William L · Santa Fe, NMN9984AWarwick Company LLC · Jupiter, FLN9984CTucker Harry B · Lexington, NCN9984EVelasco Timoteo W · South Jordan, UTN9984TOhman Mikael A · Watonga, OKN9984VValley Drug Of Malta Inc · Malta, MTN9985BJacks Charles D · Morse, LAN9985NJakab Stephen F · Wasilla, AKN9986AHerbert Wallace R · Marble Falls, TXN9986HKirkman Todd A · Chetek, WIN9986MLogan Timothy R · Valley City, NDN9986TSkylane Ventures LLC · Keizer, ORN99870Christiansen Aviation LLC · Wilmington, DEN99871Civil Air Patrol · Maxwell Afb, ALN99872Rps Holdings N99872 LLC · Magnolia, TXN9987ALewis Benjamin · Delano, MNN9987HRoger Roger Aviation LLC · Delaware, OH
Back to AD 87-20-03 R2