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.
N8326CNewman Carl D · Phoenix, AZN8326ENorton Eric D · Nauvoo, ILN8326WBarnwell Sam M · Traverse City, MIN8326YEastern Stearman Inc Trustee · Leesburg, VAN83271Nohrenberg Raymond C · Pingree, NDN83272Bowker James D · Willow, AKN83275Perry Scott D · Hood River, ORN83278Hamlin Andrew J · Two Rivers, AKN8327LFill David · Hadley, MAN8327RWelsh Rick F · Ewing, VAN8327WFuture Flying LLC · Manassas, VAN8327YKaeser Robert E · Lafayette, INN8327ZLee Steven M · Redondo Beach, CAN83281Chandler Air Service Inc · Chandler, AZN83283Hayton James B · Sedro Woolley, WAN83285Dyches Abigail · Eagle River, AKN8328CSky Craft LLC · Powell, OHN8328DJldp LLC · Chesapeake, VAN8328LArrowhead Helicopter Services LLC · Jourdanton, TXN8328PSale Reported · Lewes, DESale reportedN8328UHale Larry D · Charlotte, NCN8328WTolmachev Nikolay A · Anchorage, AKN8328YSims Chris · Colleyville, TXN8329649 Ranch Co LLC · Odonnell, TXN83299Brewer Danny E Jr · Nikiski, AKN8329VBuck Timothy A · Howland, MEN8329YHarbock Inc · Wilmington, DEN832AKOld City Helicopter Sales LLC · Saint Augustine, FLN832ATDot Aviation LLC · Wilmington, DEN832CPCivil Air Patrol · Maxwell Afb, ALN832RMMcbride Christen L · Elgin, TXN832SPRiverside Exteriors Inc · Kalispell, MTN832TBrown Rod · Ponca, NEN832TCFour Pines LLC · Grand Rapids, MNN832TFAir Fleet Holdings LLC · Missoula, MTN832WWJacobson Richard T · Overton, NVN8330LParis Air Inc · Vero Beach, FLN8330RBriggs Michael L · Howell, MIN8330VJensen Carla J · Pingree, IDN8330WRed Rock Flying School LLC · Mesa, AZN8330XHamilton Eddie D · North East, MDN8330ZLuzeski Steven · Collegeville, PAN83310Hankerd William J · Port Alsworth, AKN83312Meggers Roger D · Baker, MTN83316Meggers Roger D · Baker, MTN8331CRoanoke Valley Flying Club · Roanoke, VAN8331EPats Sales Of Ocala LLC · Ocala, FLN8331LMjl Investment Company Inc · Branchville, NJN8331PBurbanks Travis R · Tarzana, CAN8331SFly Aviation Corp · Wilmington, DE
Back to AD 87-10-06 R1