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.
N80872Yakima 872 Flying Club · Yakima, WAN80874Jls Aviation LLC · Fredericksburg, VAN8087BMach Point One LLC · Nashville, TNN8087CHartzell Propeller Employees Flying Club · Piqua, OHN8087DRa Aviation Services LLC · Sorrento, FLN8087EJd Aviation Inc · Muskegon, MIN8087PWildman Kevin · Brentwood, CAN8087YGlen John L · Warrenton, ORN80881Bizzjet Inc · Kalispell, MTN80884Rein W Clark · Ottawa, KSN8088BRegistered aircraftN8088CVouk Frank E · Firth, IDN8088YBarazani Jacob J · Chanute, KSN80896Dsr-Cherokee 180 LLC · Dallas, TXN8089CNelco Farms Inc · Fairfield, IAN8089ESkywarrior Flight Training Inc · Pensacola, FLN8089PBerryhill Daniel R · Darwin, MNN8089WBrind F Alan · Ionia, NYFirst renewal noticeN808ABSunward Aviation Services LLC · Merritt Island, FLN808BBPlane Fun Aviation LLC · Wilmington, DEN808BPChemtech-Engineering Inc · Racine, WIN808BWWeber William A · Brodhead, WIN808DCWaters John Klas · San Marcos, CAN808DDBoucher Bobbi · Fredericksburg, VAN808DJAeroquest LLC DBA · Olive Branch, MSN808DLSons Aviation Inc · Moody, ALN808DMRhoads Timothy C · Logan, NMN808DTGh Aircraft Leasing LLC · Coconut Creek, FLN808EHChristiansen Aviation LLC · Wilmington, DEN808ERDurcan David · Kingston, NYN808FLBrand Richard Jr · Alta Loma, CAN808GJWait Kyle L · Palmer, AKN808JAGrubb John P · Booneville, ARN808JPPruzek Joshua W · West Linn, ORN808JTVu Ai T · Aiea, HIN808KASchlomer Lyle M · Osseo, WIN808LLApex Helicopters LLC · Pearland, TXN808MWMy Wings LLC · Senoia, GAN808NRegistration Pending · Sarasota, FLRegistration pendingN808PWederski Lonnie E · Yarnell, AZN808PBDaniel Jeffrey Austin · Southampton, NJN808PKGottmann Matthias L · San Jose, CAN808PTDancing Bear Alaska LLC · Talkeetna, AKN808PYCollins Robert A · Modesto, CAN808RKGoehl Jeffrey A · College Station, TXN808TFAir Fleet Holdings LLC · Missoula, MTN808TYRowberry Spencer D · Grantsville, UTN808UFMahoney Clinton D · Tecumseh, NEN808VRFrank Daniel W · Lees Summit, MON808VTInternational Air Services Inc Trustee · Carson City, NV
Back to AD 87-10-06 R1