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.
N9580LBlack Carrell C · Cochranville, PAN9580MRegistration Pending · Campbellsville, KYRegistration pendingN9580URogers Ronald G · Forest, VAN9580WDestination Flyer LLC · Memphis, TNN9581GN9581g Corp · Skokie, ILN9581SKing John D · Midland, VAN9581VMartin Northern Aviation LLC · Benton, ARN9582DMontminy John · Berlin, NHN9582HMiller Timothy · Saratoga, CAN9582VCady Craig D · New Braunfels, TXN9582WBlomquist Kevin C · Kanab, UTN9583BBurke Larry Ryan · Pembroke, GAN9583JTevik Michael A · Provo, UTN9584B360 Marine · Bristol, RIN9584JLow Wing LLC · Upland, CAN9584MKing Wesley C Jr · Dayton, OHN9584PSugarbush Soaring Assn Inc · Warren, VTN9584QHoward Genetics Inc · Ardmore, OKN9584VStick & Rudder Club Inc · Waukegan, ILN9584WMitchell Gary N · Kansas City, KSN9585CEldredge Matthew · Locust Grove, GAN9585DArnt James Robert Jr · Worthington, MNN9585JHaj Aviation Inc · Cypress, TXNon-citizen corporation, flight hours not reportedN9585KPuetthoff Jan H · Mount Sterling, KYN9585LEight5lima LLC · Phoenix, AZN9585MScheuneman Carl V · Plano, TXN9585VHarrington Aviation LLC · Scarborough, MEN9585WRandolph Richard A · Gallipolis, OHN9586DHauser Nathan S · Newark, DEN9586JGeorge Neal E · Crestview, FLN9586LJones Jr Lee S · Kearneysville, WVN9586MH W S Enterprises Inc · Canal Fulton, OHN9586WAlpha 3 LLC · Troy, KSN9587JScott Jeremy A · Newark, OHN9587LWiles Robert B · Biloxi, MSN9587MNorman Bradley T · Glen Rose, TXN9587SReberg Timothy J · Bayport, MNN9587UKramer Andrew J · Sacramento, CAN9587VPinnick Brent E · West Baden Springs, INN9588DGardner Brian D · Mesa, AZN9588MDrietz Dallas A · Lake Benton, MNN9588URgm LLC · Missoula, MTN9588VKachemak Bay Flying Service Inc · Temple, TXN9589HFryar Scott D · Starke, FLN9589LVincent Jared H · Fairhope, ALN9589SJones Daniel S · Panama City Beach, FLN958CPJoslyn Larry J · Las Vegas, NVN958EGGores Thomas J · Franklin, WIN958LRegistered aircraftN958LBBevilacqua Jeffrey L · Thousand Oaks, CA
Back to AD 87-10-06 R1