AD 86-10-11 R1
Registered aircraft · 374
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:86-10-11-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:86-10-11-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:86-10-11-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:86-10-11-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.
N2806DVogt Gerald J · Erie, PAN28071Korn Bruce · Mindoro, WIN2807NJbc Aeronauts LLC · Colorado Springs, CON2808CBush Stewart D · Rio Rancho, NMN2810DIrvin Ronald L · Derby, KSN28120Carrigan Meron Robert · Murrieta, CAN2815BIcxing LLC · Prineville, ORN281MSWiederkehr Matt H · Centerville, MNN28282Reichhart Richard B · Honeoye Falls, NYN28366Krieg Fred W · Independence, ORN2847NPost William S · Custer, WAN2854AHodges Eric C · Rio Rancho, NMN2864EBallooning Adventures Of Colorado LLC · Denver, CON28724Zemlachenko Michael · Cape Canaveral, FLN2876DJutras Joan C · Loxahatchee, FLN29236Atwill John R IV · Vancouver, WAN29417Sommers Christopher Alan · Slatington, PAN2941KWilliams Scott M · Gales Ferry, CTN3009RWagoner David F Jr · Pasadena, MDN3015RDicocco Anthony Jr · Pennington, NJN3081RLamontagne Seth A · Pittsfield, NHN3303XRoss Fred · Hollywood, FLN35541Chando Morghan E · Albuquerque, NMN3554DDrake Richard R · Radcliffe, IAN3556BKramer David A · Fort Edward, NYN3557CMarketing Services Inc Of Pueblo · Colorado Springs, CON35631Nemesis Balloon Team LLC · Helena, MTN3565GLucas Robert · Decatur, ALN3566KNewberg Edgar T · Hector, MNN35693Hatfield Jason G · Gardnerville, NVN35694Oswald Donald W · Palmdale, CAN3570GBradley Kenneth P · Evans, CON3575GSproul Keith A · North Brunswick, NJN3578DMccombs Audrey L · Albuquerque, NMN3580LGarrett Terry S · Indianola, IAN3581UBowie Mark · Greenwood, MSN3585DErwin Keith S · Milford, NJN35863Mouser Emily S · Canton, OHN3587BLight Flight Balloons Inc · Bel Air, MDN3592CCasey Vincent J · Sparks, NVN35934Hot Air Ad-Ventures Inc · Tampa, FLN3596SShumate Kenneth W · Orlando, FLN3597XHunter Seth A · Farmington, NMN3598VWiltermuth Brent · Clarissa, MNN3604QShumate Kenneth W · Orlando, FLN36089Jutras Joan C · Loxahatchee, FLN36144Grissom Timothy G · West Liberty, OHN36426Dzilinski Gene S · Lehigh Acres, FLN36497Salsbury David K · Jackson, MIN4007RMcdermitt Michael G · Phoenix, AZ
Back to AD 86-10-11 R1