AD 2012-11-08
Registered aircraft · 177
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:2012-11-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-11-08')
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:2012-11-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-11-08') 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.
N80JVBaker Aviation Consulting LLC · Summerland Key, FLN821KSdl Enterprises LLC · Akron, IAN827GLEtchart Joseph O · Glasgow, MTN828KLumley William B · Delray Beach, FLN833KAshley James M · Greenwood, SCN834KHoover Michael B · Ridgeland, WIN837KRouth Gary Lee · Lebanon, TNN839KMorozowsky Anthony M · Zanesville, OHN841HSaure Cameron G · Reynolds, NDN849DDBishop David · Butlerville, INN856LSlack Troy Trustee · New Concord, OHN85GLAviation Insurance Managers Inc · Uniontown, OHN863KCronin Robert B Jr · Candia, NHN864KRouth Gary L · Lebanon, TNN866KSdl Enterprises LLC · Akron, IAN86WSPlane Fun Inc Tr Trustee · Snellville, GAN874KGreat Lakes Aircraft LLC · Palmer Lake, CON87GBertacchi Lawrence · Vineland, NJN87GLPendleton Terry S · Salisbury, NCN882BKRegistered aircraftN909NPreston Robert J · Pittstown, NJN915NMadden William L · Las Cruces, NMN95HCCrosswell Joe · Springtown, TXN97GLHarrison Christopher J · Danville, CAN997WTRxy LLC · Gilbert, AZN99GLCristy Daron James · La Jolla, CAN9GLCampbell Joseph P · Vail, AZ
Back to AD 2012-11-08