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.
N833JRWagwad LLC · Manlius, NYN833MAberle Jonathan Andrew · Denver, NCN833RCTime Machine Adventures LLC · Minot, NDN833RTNash LLC · Carbondale, ILN833SD3 Sierra Delta LLC · Orange, CAN833SRN833sr LLC · Mount Sterling, KYN833TXN833tx LLC · Little Rock, ARN8345QKatahdin Air Service Inc · Hermon, MEN834AKGilreath Todd L · Benton, LAN834CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYN834HSN873wt Aviation LLC · Lewes, DEN834LAHampton Jeffrey · Wayne, ILN834LCOver And Out LLC · Sevierville, TNN8352QUnited Indian Missions DBA · Tucson, AZN8356NNielson Frederick P · Mesquite, NVN835MSBeasley Michael P · Byron, GAN835ZCoastal Cirrus LLC · Aliso Viejo, CAN836JBReis James C · Lake Ozark, MON836LGFly A36 LLC · Browntown, WIN836RFNuage Software Corp · Saint Petersburg, FLN836ZJAltera Group LLC · Brentwood, TNN837DD Flight School LLC · Altoona, PAN837EGZachariah Craig Powell · Salina, KSN837MLBombero Aviation LLC · Childress, TXN837MMSouthern Aircraft Consultancy Inc Trustee · Casper, WYN8386M213tz LLC · Hailey, IDN8388GTrombly Daniel · Franklin, NHN8388TEmerald Aviation Inc · Miami, FLN838CDQualitair LLC Trustee · MichelstadtN838GGirus Cirrus Inc Trustee · Wilmington, DEN838WPHeartland Air Leasing LLC · Coon Rapids, MNN8394QPacific Union College · Angwin, CAN839CRDonnellan Aviation Inc · White Plains, NYN839CTFast Flyers Aviation Partners LLC · Leawood, KSN839HFFour Boys Flying LLC · Kalispell, MTN839SR839sr LLC · Rocky Mount, NCN839WXBezner Partners LLC · Texline, TXN83CCDelta Delta LLC · Fargo, NDN83CEElsner Kelly J · Menahga, MNN83CMSchmitt David W · Sylvania, OHN83DLake Placid Flying Service Inc · Lake Placid, NYN83FLHoopoes Holding LLC · Newton, MAN83GHTebow William · Bunkie, LAN83HBJennifer Air LLC · Mooresville, NCN83JTLewis Thomas · Belton, TXN83KKLowe Aviation Co · Macon, GAN83MWMarine Warehouse 3 Inc · Wilmington, NCN83PBHyannis Air Service Inc DBA · Hyannis, MAN83RJMckenzie Aviation Corp · Port Orange, FLN83UMRegistered aircraft
Back to AD 2012-10-13