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.
N727JHAlbert Lea Airport Inc · Albert Lea, MNN727JWWiegenstein John H · Hansville, WAN727KWilliam L Schmidt Attorney At Law Pc · Fresno, CAN727KRRogers Ronald J · Crystal Lake, ILN727LDDonceel Leslie G · Murphy, NCN727LFLanier Equipment Leasing LLC · Gainesville, GAN727LGYouth & Aviation Inc · Thiensville, WIN727MAMarc Inc · Bolton, MSN727METruesdell Shannon · Stephenville, TXN727MFFaatz Mitchell R · Auburn, CAN727MRUnavex Inc · Pensacola, FLN727MZLmb Aire LLC · Howell, MIN727PANorat Richard N V · Kerrville, TXN727PEPhoenix East Aviation LLC · Daytona Beach, FLN727PMMiddlebrook Paul E · Penn Yan, NYN727PSGardner Timothy J · Gardnerville, NVN727RStyer David L · Mount Gilead, OHN727RCKelley Aircraft LLC · Weyers Cave, VAN727RHRegistered aircraftN727RLHammerton Kenneth R · Olive Branch, MSN727RMMarkle Robert L Jr · Cranberry Township, PAN727SDStable Air LLC · Leonardtown, MDN727SFRenko Steven E · Elmira, NYN727SPElite Approach LLC · Chesterfield, MON727TCSandpiper Air LLC · Dickinson, TXN727TDLean Aviation LLC · Saint Augustine, FLN727TGWolf Aviation LLC · Beaufort, SCN727TLLangebrake Lawrence C · Saint Petersburg, FLN727TMModesto Vapor Trails · Modesto, CAN727TSStreng Terry E · Columbus, OHN727TVTuskegee Eagles Of St Jeseph Mo · Agency, MON727VTFeber David G · Los Gatos, CAN727WMMd Air Ops LLC · High Springs, FLN727ZWBergen Brady · Junction City, KSN72805Ace Aviators LLC · New Baltimore, MIN7280CGriff Air LLC · Aurora, ORN7280DLavin Gregory S · Chugiak, AKN7280FHarmon Sharon O · Pasco, WAFirst renewal noticeN7280ZGalt Ranch Aviation LLC · Wht Sphr Spgs, MTN72819Mccune Ken · Lake Havasu City, AZN7281DMartin Michael J · Anchorage, AKN7281JBilbrey Don R · Georgetown, OHN7281PGuardian Peaks Airways LLC · Portland, ORN7281YGo For Flight LLC · Minneapolis, MNN7282ABell Helicopters LLC · Melbourne, FLN7282JWirth Alan Patrick · Callaway, MDN7282LPennau Karl · Fond Du Lac, WIN7282NWtm Consulting LLC · Williamsburg, VAN7282VBrant Owen D · Delta Jct, AKN7282WHoracio Marcelo Knop · Hialeah, FL
Back to AD 87-10-06 R1