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.
N809KPDepartment Of Homeland Security · Washington, DCN809LNDepartment Of Homeland Security · Washington, DCN809MBerkshire Aviation Enterprises LLC · Great Barrington, MAN809NDDepartment Of Homeland Security · Washington, DCN809PGDepartment Of Homeland Security · Washington, DCN809QJDepartment Of Homeland Security · Washington, DCN809RHDepartment Of Homeland Security · Washington, DCN809SEDepartment Of Homeland Security · Washington, DCN809STDiaz Natanael Luna · Toa Baja, PRN809TFAir Fleet Holdings LLC · Missoula, MTN809TTDepartment Of Homeland Security · Washington, DCN809USDepartment Of Homeland Security · Washington, DCN809VADepartment Of Homeland Security · Washington, DCN80AMGreat Lakes Aircraft LLC · Palmer Lake, CON80ANStephany Peter T · Umatilla, FLN80ASAlpha Sierra LLC · Simi Valley, CAN80BADelcambre Willard J · Grand Coteau, LAN80BDJtr Aviation LLC · Canton, TXN80BJRegistration Pending · Jasper, GARegistration pendingN80BRN80br LLC · Port Orange, FLN80CEGarden Kevin · Collierville, TNN80CHMoyer Hunter · Rapid City, SDN80DECampbell Bradford D · Groton, CTN80DJShireman Kirk A · Pearland, TXN80DKAutoair Research Inc · Wilmington, DEN80EEEagle Enterprise LLC · Granbury, TXN80ERModular Solutions Inc · Kinston, NCN80EZHolliday Mathew J · Limerick, PAN80FFP A M Aviation LLC · Portsmouth, NHN80FGFlightgest Academy LLC · Morrisville, NCN80FPCarastro Enterprises LLC · Montgomery, ALN80FTWifa (Washington International Flight Academy) LLC · Gaithersburg, MDN80GGOgg Richard A · San Lorenzo, CAN80GLNear William J · Weirsdale, FLN80GSCassell Robert W · Wasilla, AKN80GVMoro Aircraft Leasing Inc · Two Rivers, AKN80HULast Waterhole LLC · West Richland, WAN80HYBrooks Eugene D IV · Cross Plains, TNN80JVBaker Aviation Consulting LLC · Summerland Key, FLN80KARowe Andrew · Palmdale, CAN80KDKnutson Kevin J · Lakeville, MNN80KMMcphillips Flying Service Inc DBA · Beaver Island, MIN80LCHubbert Stephen A · Newcastle, OKN80LFAeromarine Holdings LLC · Waukesha, WIN80LKEti Aviation LLC · Boynton Beach, FLN80LSClow Streeter M · Mansfield, OHN80LTEastern Stearman Inc Trustee · Leesburg, VAN80MLBishop Jack · Sabina, OHN80MMTodd Patrick A · Lockeford, CAN80NDMerrifield Robert Craig · Fitzgerald, GA
Back to AD 87-10-06 R1