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.
N461BCB&K Leasing Inc · Nantucket, MAN461CAMach II LLC · Carlsbad, CAN461CDRiver City Leasing LLC · Lakeville, MNN461DKMark Andregg Dds Pc · Tulsa, OKN461EDp Aviation LLC · Nixa, MON461MGHangar 94 LLC · Niwot, CON461SRRiechers Peter Trustee · Napa, CAN4620YCenturion Travel LLC · Fort Worth, TXN4623FHatfield William G · Nunica, MIN4624KHoyt Matthew P · Newport Beach, CAN4626KWyeth Patrick B Trustee · Chino Valley, AZN4627KIsbell Brian · Rosenberg, TXN4627QMassey Larry A · New Braunfels, TXN4629KAuburn Farms LLC · Auburn, KSN462CAKinslow Aviation LLC · Prague, OKN462CDSouth Fork Group LLC · Belmont, NCN462CPPonozzo Donald A · Plainwell, MIN462DLDanmar Leasing LLC · Little Rock, ARN462HSAmelia Ann Cruzing LLC · Sibley, LAN462PT4888 Aviation LLC · Peachtree Corners, GAN462TJJohnson River LLC · Durant, OKN462WWPlane Metrics LLC · Fort Worth, TXN4630NHyannis Air Service Inc · Hyannis, MAN4631CGraves Martin · Odessa, TXN4635GN535j LLC · Bismarck, NDN4636KAdvanced Database Designs LLC · San Ramon, CAN463CZCzabaranek Joseph A · Bellevue, WAN463DPDouble Play Aviation LLC · Crossville, TNN463KJCc Equipment Holdings LLC · Zionsville, INN4640GHonea Richard S · Canton, GAN4644UWineglass Holdings LLC · Fort Davis, TXN4648ATimms Chet D · Central City, IAN464KBStillwater Aviation LLC · Belmont, CAN464MMeyer Brent · San Antonio, TXN464PCJordan Thomas Harvey III · Jasper, GAN464WHInfinite Loop Aviation LLC · Granite Bay, CAN4653Q53 Quebec LLC · El Dorado, CAN4654MJetway LLC · Dover, DEN4656KValley Agriculture LLC · Galt, CAN465CPN465cp Partners LLC · Sugar Land, TXN465DLKeystone Aerial Surveys Inc · Philadelphia, PAN465JRegistered aircraftN465KJBvw Aviation LLC · Grand Rapids, MIN465SAGilmore Air LLC · Boca Raton, FLN465TXLsa Aircraft Holdings LLC · Houston, TXN465TYBear Flight LLC · Atlanta, GAN4660JStuder Al C · Shelby, MIN4665CKrissman Ryan · Gallup, NMN4668NSre Holdings LLC · Dewitt, MIFirst renewal noticeN466CAHyannis Air Service Inc DBA · Hyannis, MA
Back to AD 2012-10-13