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.
N674SRTorres Mark D · Columbia Falls, MTN674TCUS Department Of Homeland Security · Washington, DCN674TGStallion Air LLC · Springtown, TXN6750HPickett Michael R · Gig Harbor, WAN6750JAmin Kirit · Lansdale, PAN6750UFischer James C · Falls City, NEN6750WNelson Laura Leigh · Gastonia, NCN6751BCook Harry F · Sequim, WAN6751JJones James L · White Hall, ARN6751NParr Matthew R · Wellsville, PAN6751PGette Jason D · Kindred, NDN6751VManley William T Jr · Lakeside, TXN6751YLarson Kris K · Fullerton, CAFirst renewal noticeN6752JHutchins James R · Columbia, SCN6752ULucarelli Michael · Surprise, AZN6752ZVector USA LLC · Olive Branch, MSN6753BThorpe Brandon · Bremerton, WAN6753JSpieth John W · Ann Arbor, MIN6753NHarmon Benjamin P · Olive Branch, MSN6753PScanlon Shawn M · Evans, GAN6753VDegraffenreid Donald R · Fort Mohave, AZN6754NCasady David E · Harriman, TNN6754VTharp Kenneth Lynn · Apple Valley, CAN6754YNovember Nine One Four Eight Juliet LLC · Fulton, MON6755BTwotards Aviation LLC · Moses Lake, WAN6755JBon Investment Holdings LLC · Zephyrhills, FLN6755PHensler Carl P · Watsonville, CAN6755WAeroqualite Maintenance · Cumberland, WIN6756BNortheast State Community College · Blountville, TNN6756JAmv Aviation LLC · Miami, FLN6756UBergland John E · Santa Monica, CAN6756VFelicione Frank S Jr · Idaho Falls, IDFirst renewal noticeN6756WTrollinger Lari D · Wanette, OKN6756ZKoenig Donald J · Las Animas, CON6757BStuart Lee L · Smithville, ARN6757NCoody John A · Idaho Falls, IDN6757UScherger Mark A · Herndon, VAN6758HGorge Winds Aviation Inc · Fairview, ORN6758JBroach William S · Forest Hill, MDN6758NZwerko Kevin C · South Plainfield, NJN6758PRoss David T · El Dorado Hills, CAN6758UN6758u LLC · Linden, MIN6759BDean Richard L · Ridgeland, SCN6759UHodgson Michael D · Saint Francis, WIN6759WMakeev Alexandre · Concord, CAN675CPCalifornia Polytechnic State University · San Luis Obispo, CAN675JBRegistered aircraftN675KAAllis Kevin J · Columbia, MDN675LHFf22 LLC · Scottsdale, AZN675MPN9sa Corp Trustee · Wilmington, DE
Back to AD 87-10-06 R1