AD 63-06-02
Registered aircraft · 211
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:63-06-02')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:63-06-02')
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:63-06-02') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:63-06-02') 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.
N1313BSwanland Robert C · San Jose, CAN131HPrentice Robert D · Ripon, WIN13235Kimbrel Michael G · Oakville, WAN132FPendergrass Glen · Plainview, TXN1413AKing John D · Midland, VAN1413BSimpson Bradley C · Grandview, TXN14396Tobias Eric · Milwaukee, WIN242Ohlmer Ted J · Monterey, CAN29TJRegistration Pending · Bear Creek, PARegistration pendingN33GMMeulenberg Jacobus Mj · Schenevus, NYN413RPalmer Earl S · Lewiston, IDN427Olson Wesley M · Clovis, NMN44FPShipman William L · Mc Calla, ALN4974ARegistered aircraftN500AKiehl Timothy A · Glendale, AZN503AMatulewic Robert S · Alhambra, ILN505AIvy James H III · Seligman, AZN508AKimball Stephen W · Columbus, NMN510AWhite Raymond W · Montrose, MIN511ADoorenbos Rodney J · Washburn, MON515AGodlasky Charles A · Powell Butte, ORN519ALester John M · Okanogan, WAN520ALentz Blaine D · Laramie, WYN536AScgi Inc · Griffin, GAN538APontious Alfred A · Mojave, CAN540ABarnow Jeffrey W · Boulder, CON6504NBrown Justin G · Folsom, CAN6506NThoms Robert D · Clyde, MIN6507NEack Kenneth B · White Rock, NMN6508NRegistration Pending · Independence, ORRegistration pendingN6520NDemeyer Scott M · Olympia, WAN6523NJenkins Grant W · Seattle, WAN6553NBeattie Joseph D · Manitowoc, WIN6555NRobinson Thomas G · Arlington, TXN6558NDickson Bernard G · Chiloquin, ORN6560NVano Sally L · Carlos, MNN6565NPerino Joseph P Jr · Carrollton, TXN6567NSeratt Timothy G · Harviell, MON6569NSchimmel O L · Port Hueneme, CAN6575NPenney John C Trustee · Evergreen, CON6577NBartels Lance R · Freetown, INN6578NOxford Sherman D · Flower Mound, TXN6579NYork Ben III · Mesa, AZN6582NPenney John C Trustee · Evergreen, CON6587NBullock David R · Jarales, NMN6592NDe Mar David W · Corrales, NMN6596NCleis Richard A · Kihei, HIN6597NCherry Hill Aviation Inc · Freetown, INN6RJSkyway Leasing Inc · Mosheim, TNN73KVlk Mark J · Moses Lake, WA
Back to AD 63-06-02