AD 2012-10-13
Registered aircraft · 13,306
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-10-13')
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-10-13')
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-10-13') 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-10-13') 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.
N685DMMetcalf Steven · West Union, IAN685SRRegistration Pending · Seattle, WARegistration pendingN685TLSeefeeltrust LLC · Gypsum, CON6867CHelms Foodservice Inc · Lake City, FLN6869LWeatherby Joseph III Trustee · Cuyahoga Falls, OHN6869RPro Air Media LLC · Sevierville, TNN686DSScheigert Delbert F Jr · Saint Cloud, FLN686JPJp Aviation LLC · Atlanta, GAN68707Ascp Blue Skies LLC · Columbia, MON6870MApplied Science Services Corp · Woodland Hills, CAN68717Horst Paul A · Clarkrange, TNN6871DPickett Aviation LLC · Brownsboro, ALN68752Hyannis Air Service Inc · Hyannis, MAN6875DHyannis Air Service Inc · Hyannis, MAN6879RHyannis Air Service Inc · Hyannis, MAN687CWUniversity Lakes Property LLC · Miami, FLN687PWDragonflier LLC · Las Vegas, NVN687SAGerstein Lee · Park City, UTN687WTCharlie Delta Group LLC · Bismarck, NDN688CJtc Properties LLC · Carmel, CAN688ERWolf Kenneth P · Orange Park, FLN688LDRoper Technologies Inc · Sarasota, FLN688PDUnusual Attitudes LLC · Bates City, MON688SPSanchez Eddy B · Miami Gardens, FLN688SRRsm Enterprises LLC · Helena, MTN6899BCowgill Robert W · Amissville, VAN689CAir Mt A36 LLC · Lake Havasu City, AZN68AWTas Aircraft Sales LLC · Troutdale, ORN68BARegistered aircraftN68BMDavenport Donald · North Las Vegas, NVN68DXFreeman David J · Seattle, WAN68EAPav East LLC · Camden, DEN68FRManz Aviation Services LLC · West Reading, PAN68GTBoon Hong Sim · New York, NYN68GYOwll Aviation LLC · Baton Rouge, LAN68JFAjs Aviation LLC · Warroad, MNN68JWBobcat Aviation LLC · South Hutchinson, KSN68KLVoloshin Vitaly · Seattle, WAN68MGDreger Dean R · Wilbur, WAN68MMLetters Inc · Santa Maria, CAN68NQRounds Dana H · Vacaville, CAN68PFWooden Steve S Trustee · Nokomis, FLN68SYFreeman William M · Cameron Park, CAN68TBSmith Ronald A · Los Gatos, CAN68WBFloatron Inc · Phoenix, AZN68WTFront Range Cirrus LLC · Denver, CON6900XMueller Robert C · Reno, NVN6908PSix Six Hotel Corporation · Bangor, PAN6908XSky West Aviation Inc Trustee · Albuquerque, NMN690NDAltitude Adjustment LLC · Lisle, IL
Back to AD 2012-10-13