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.
N870CDZugski LLC · Nederland, CON870CHBuzz Light LLC · Baton Rouge, LAN870CVValiair Lc Trustee · Casper, WYN870FSLindsey Norman A · Richardson, TXN870FVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN870UOhio University · Albany, OHN870VLCaribbean Flyers LLC · San Juan, PRN870WPMartin Scot · Las Cruces, NMN8711KGraham Thomas R · Bonita Springs, FLN8712KKirkmeyer Thomas · Kimberly, IDN871ANWnd Aircraft Management LLC · Miami, FLN871DLRegistered aircraftN871JBAas Baron LLC · Houston, TXN871JKKafer John H Trustee · Troy, ILN871TXNlmds Leasing LLC · Tierra Verde, FLN871VLZee Enterprise Inc · Chicago, ILN8720KZielinski John P · Queen Creek, AZN87221Chester Darren Dw · Sioux Falls, SDN8725QN8725q LLC · Grand Junction, CON8727387273 LLC · Reno, NVN8727KFrosty Acres LLC · Hailey, IDN87293Dinaland Aviation · Vernal, UTN872CDOmk Freedom LLC · Los Angeles, CAN872CPRohman Diane L · Vero Beach, FLN872SRSteward Builders · Weatherford, TXN872WHTheologos Charles · Waveland, MSN872YHoward Donald · Farmington, NMN87356Kovacs Endre · Plant City, FLN87393310 Amigos LLC · Stuart, FLN873MMInternational Air Services Inc Trustee · Carson City, NVN873WHG & A Viation LLC · Miller, MON87443Keystone Aerial Surveys Inc · Philadelphia, PAN87481Petersen Donald W · Bullhead City, AZN874BHNsd Air LLC · Osage Beach, MON874CDEmerald Coast Pilots LLC · Panama City, FLN874CPRm Aviation LLC · Clarkrange, TNN874DCFour Delta Charlie LLC · Fort Wayne, INN874WBEndurrence Aviation LLC · Savannah, GAN874WHRed Oak Aviation LLC · Sunset, LAN87536Krull Jesse L · Bismarck, NDN8756QTriple 2 LLC · Burlington, CON8758QBerge Christian · Mccall, IDN875JTCw Wings LLC · Sandy, UTN875PLBenvenuti Darel · Newport Beach, CAN8765TBluefin Water Solutions LLC · Purcell, OKN876AAAwalt James Clinton · Lago Vista, TXFirst renewal noticeN876AHMja Sr22t LLC · Belleville, ILN876CPScg Consulting LLC · Myrtle Beach, SCN876DYDak Aviation LLC · Lake Lotawana, MON876R76r Holdings LLC · Rockport, TX
Back to AD 2012-10-13