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.
N8180FTag International Corporation Inc · Sheridan, WYN8180MLeap Aviation Inc · Wilmington, DEN8180PGriffin Robert · Middletown, DEN8180WD And D Air Inc · Paola, KSN8180YG2g Aviation LLC · Wray, CON8181DMuleshoe Ranch Inc · Belle Fourche, SDN8181HLao Investments LLC · Meeker, CON8181NBald Eagle Flying Club · South Portland, MEN8181PTascosa Trail Inc · Gruver, TXN8181XStelling William F · Fairbury, NEN8182BMorgan William J · Plano, TXN8182ERed Arrow Aviation LLC · Santa Teresa, NMN8182NJlf Air Inc · Evansville, INN8182PFaulkner Ronnie L · Mount Ida, ARN8182WSwillen Richard Carl · Easley, SCN81830Wilkins Raymond E · Osceola, IAN8183DReabe Robert E · Waupun, WIN8183NTucker Richard D · Locust, NCN8183XStill Jeffrey · Powder Springs, GAN81843Sorensen Paris K · Murrells Inlet, SCN81844Abrams Adrian L · Palmer, AKN8184CRouse Michael R · Wilson, NCN8184GAspire Aviation LLC · Farmingdale, NYN8184HPedersen Gregory S · Spring Hill, FLN8184WBaker John L · Killen, ALN8184XHarding Phyllis · Santa Rosa, CAN81853Hobbs Christopher · Truckee, CAN81858Strohauer Farms Inc · La Salle, CON8185ARiggin William J · Carterville, ILN8185CKirkland Kerry G · Spring, TXN8185NWright Edward J Jr · San Antonio, TXN8185WAlaska Media LLC · Anchorage, AKN8185YCarter Gregory A · Edmonds, WAN81866Wellness Flight LLC · Sarasota, FLN8186DAmg Industrial LLC · Ashburn, GAN8186FN8186f Inc · Danville, INN8186KBlack Hills Soaring Club Inc · Rapid City, SDN8186NMorris Thomas L · Fairmont, WVN8186YHeiter Aviation Services LLC · Leesburg, INN81876Purcell Diane Diez · Baton Rouge, LAN81877Ansen Leasing Co · Boone, NCN8187DSchmidt Darrell · Kimberly, IDN8187PKlein Dale A · Mandan, NDN8187TLawdawg Property Rentals LLC · Williston, NDN8187WViroqua Area Flyers Inc · Viroqua, WIN8187XStevenson William E · Holton, KSN8187YWhite Jack S · Boone, NCFirst renewal noticeN81888Zion Thomas C · Middleboro, MAN8188CSlayden Steven M · Rhome, TXN8188JCrossbrook LLC · Willoughby, OH
Back to AD 87-10-06 R1