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.
N8203WCarter Terry A · Clinton, ARN8203YMn98 LLC · Belview, MNN82044Chandler Air Service Inc · Chandler, AZN82045Paris Air Inc · Vero Beach, FLN82048Newton Property Leasing LLC · Greene, IAN8204JKusa Aviation LLC · Beaumont, TXN8204NNielson Rex W · Pendleton, ORN8204WJeffery Gordon Paul III · Kirkland, WAN8204YBlue Steele LLC · Barnegat, NJN82053Kleinknecht Richard C · Burtchville, MIN82054Fusaro Ronald G · Westerly, RIN82057Morelli Michael L · Eagle River, AKN82058Hunt Brackston C · Elaine, ARN8205APilot Place LLC · Sarasota, FLN8205EChandler Air Service Inc · Chandler, AZN8205GYoung Charles D · Athens, TXN8205WShockey Michael J · Dumas, TXN82063Richards Brian W · Soldotna, AKN82064Wells Joseph E · Dorchester, SCN82065Yundt Joshua J · Wasilla, AKN82067Knutson Wayne R · Thompson, NDN8206EA Kelly Aviation LLC · New Braunfels, TXN8206HJonathan Designs Inc · Cape Coral, FLN8206PMente Charles E · Ocala, FLN8206WMedia Stew LLC · Carson City, NVN8206YBauer Electric Inc · Winona, MNN82071Vintage Aircraft LLC · Leesville, SCN82075Miloud Chadd K · Fort Worth, TXN82076Kustatan Leasing LLC · Nikiski, AKN8207NRohner Harlan G · Willmar, MNN8207PReed Thomas F · Wichita, KSN8207TColorado Aircraft Maintenance Solutions LLC · Denver, CON8207YTwinkie Air LLC · Colville, WAN82084Dorion David R · Asotin, WAN82085Read Lawton · Meredith, NHN8208EChamplain Island Hoppers · Burlington, VTN8208NMwh Consulting · Justin, TXN8208PGallacher Edwin T · Salt Lake City, UTN8208YAirswiss Inc · Wilmington, DEN82096Mid Atlantic Soaring Assoc · Frederick, MDN82097Argosy Venture Corporation · Pagosa Springs, CON8209EAnywhere Atp LLC · Mount Juliet, TNN8209FRich Ivan H Jr · Memphis, TNN8209PFox Black Enterprises Inc · Kilmarnock, VAN8209WRegistered aircraftN820BTJjsap Holdings LLC · Kalispell, MTN820CPCivil Air Patrol · Maxwell Afb, ALN820FSAir Arctic Inc · Fairbanks, AKN820GAtp Aircraft 9 LLC · Wilmington, DEN820HGGeorgia Aviation Authority · Eastman, GA
Back to AD 87-10-06 R1