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.
N6856YAviation Data LLC · Carson City, NVN68572Precision Guided Solutions LLC · Sioux Falls, SDN68573Etherington Sara L · Belton, MON68574All Attitude Aviation Inc · Edgewater, FLN68576Robinson Neil A · Madison, WIN6857HNew Mexico Flying Eagle Inc · Tucson, AZN6857PHuntsman John E · West Linn, ORN6857STailgate LLC · Felton, GAN6857UShabotynskyj Kathleen · Palm City, FLN6857WN6857w Inc · Palos Heights, ILN6857YGraves Jessica M · Anthony, KSN6857ZBarrett Jane T · Tehachapi, CAN6858HPrairie Skies Aviation LLC · Hutchinson, KSN6858NBarnes Kevin Lee · Greensboro, MDN6858UMattingly James P · Edwardsville, ILN6859HRoeper Gary Lee · Linden, MIN6859JDobberfuhl Roy · Cedarburg, WIN6859NLozar Dianne C · La Harpe, ILN6859PPlowman Joseph E · Longmont, CON6859UFischer John C · North Highlands, CAN6859ZEd Air Inc · Oaktown, INN685ACMullerhill Inc · Hillsboro Beach, FLN685ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEN685FLDadson Tach LLC · Mesa, AZN685JAYale Companies LLC DBA · Indianapolis, INN685JBMichels David A · Louisville, KYN685KMN685km LLC · Wilmington, DEN685LHChristiansen Aviation LLC · Wilmington, DEN685MAYale Companies LLC DBA · Indianapolis, INN685MDAbacus Automation Inc · Bennington, VTN685NDUnd Aerospace Foundation · Grand Forks, NDN685SPDirty Side Down Aviation LLC · Georgetown, TXN6860HUniversity Of Michigan Flyers · Ann Arbor, MIN6860JApm Leasing LLC · Casper, WYN6860PRegistered aircraftN6861HViking Systems Inc · Naples, FLN6861JEwart Mark A · Shoreacres, TXN6861NCooke Douglas L · Ventura, CAN6861WLoffeimancher Richard P · Eastvale, CAN6862HStrickland J A · Fairbanks, AKN6862JTraut Joseph W · Sharon, MAN6862PWeber Phillip A · Stroudsburg, PAN6862UCromer Chet T · Anderson, SCN6862WFly Dynasty Corp · Ocala, FLN6862ZSimmons Aviation Services LLC · Pawcatuck, CTN6863FKaminski Joseph J · Port Orange, FLN6863TBering Capital LLC · Anchorage, AKN6863UHoppe Joel A · Mankato, MNN6863WThrust Vector LLC · Austin, TXFirst renewal noticeN6863YDempsey Donald B · Deland, FL
Back to AD 87-10-06 R1