AD 87-10-06 R1
Registered aircraft · 72,010
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-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.
N932UWRegistration Pending · St George, UTRegistration pendingN932WSMarg Aviation Enterprises LLC · Lawrenceburg, TNN932WTRose Doug · Anderson, INN932XWoodward Chris Calvin · Arvada, CON9330BCarpenter Michael R · Wasilla, AKN9330JTinaga Resorts Corp · San Angelo, TXN9330VWest Daryl DBA · Kirkland, WAN9330WMarcy Michael S · Farmington, NMN9331JSkysight Consulting LLC · Memphis, TNN9331PAmra Nabil · Chaska, MNN9331VMartin Edward J · Poplar Grove, ILN9331WBallou Wesley S · Houston, TXN9332DMartin Clint R · Escondido, CAN9332JKnutson Wayne R · Thompson, NDN9332MKasakoff Lloyd · Diamond Bar, CAN9332NSloan Donald W · Dover, DEFirst renewal noticeN9332WWicker Kevin N · Beechgrove, TNN9333FFire Bird Aviation Inc · Vivian, LAFirst renewal noticeN9333JRau Alan · Java, SDN9333MMalaka Air LLC · Bradenton, FLN9333NGlendale Community College · Glendale, CAN9333PSky West Aviation Inc Trustee · Albuquerque, NMN9333VFletcher Jeffrey A · Belle Chasse, LAN9333ZLong Todd A · Maple Plain, MNN9334CBadzinski James P · Roseville, MNN9334HFree State Flying Club · College Park, MDN9334MLee Gary L · Aberdeen, IDN9334NRoberson Ronald M · High Ridge, MON9334RMirolla Michael · Lake Balboa, CAN9334SFontaine & Associates Inc · Pearl, MSN9334VSwope William T · Georgetown, OHN9335MPerry Christopher T · Eugene, ORN9335SKeep Climbing LLC · Las Vegas, NVN9336DSitta Donald C · Farmington, NMN9336MRioux Roger J · Corpus Christi, TXN9336WForbes Eric L · Pahrump, NVN9337CLovett Zachary · Fort Worth, TXN9337DNantz William G Jr · Raleigh, NCN9337EMarianas Air Transfer Inc · Saipan, MPN9337HLorraine'S Blue Sky Aviation LLC · Norman, OKN9337JHudson Kenneth J · Caswell Beach, NCN9337KSkyrise Aviation Corp · Pompano Beach, FLN9337NHoward Robert L · Jacksonville, NCN9337PWesterfield John III · Birmingham, ALN9337SDalton Stephen P · Lewistown, PAN9338BTopp Jason · Grace City, NDN9338CSmart4 LLC · Kissimmee, FLN9338HSchab Davis Maragaret A · Spangle, WAN9338JCarr Shelby · Stevenson, ALN9338NForker Thomas S · Williamsport, PA
Back to AD 87-10-06 R1