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.
N565SPattarini James Martin · Houston, TXN565TVCca LLC · Wellston, OKN565TX22t-10685 LLC · Austin, TXN566BLGuardian Health Clinic LLC · Rayville, LAN566EAKbs Air LLC · Madison, MSN566SRFutures Aviation Services LLC · Sunny Isles Beach, FLN566TLBilly D Lide LLC · Streetman, TXN566TTLochhead Aviation LLC · Scottsdale, AZN56722Tri-Valley Advisors Inc · Pleasanton, CAN5677XKas Properties LLC · Jennings, LAN567ABPiper Aviation LLC · Lewes, DEN567ATIko Aero Services LLC · Natchez, MSN567CTAvion Sr22 LLC · Schaumburg, ILN567DEclipse Inc · Sharon Springs, KSN567DMAircraft Guaranty Corp Trustee · Oklahoma City, OKN567DTCenturion Aviation Inc · Kalispell, MTN567JGRapid River Aviation LLC · Boulder City, NVN567JJCarefree Coach LLC · Thayne, WYN567KCWelch Darrnell M · Hillman, MIN567MB1 And 3 Lc · Jenks, OKN567MGHay-Con Aviation LLC · Winter Park, FLN567PAS & H Aviation LLC · Beaumont, TXN567PFD & W Air LLC · Broken Arrow, OKN567PMValiair Limited Company Trustee · Casper, WYN567RTBoac 1 LLC · Knoxville, TNN567SRGoal Aircrafts Corp · Orlando, FLN5680CSea Spray Aviation LLC · New Smyrna Beach, FLN5688C5688c LLC · Glendale, AZN568HBKurreck Tim R · Caldwell, IDN568SRHaney Jeffrey · Carrollton, GAN568TWWestray James H · Gainesville, GAN568YSpectrapower LLC · Livermore, CAN5690CTailwinds Aircraft Holdings LLC · Harrisburg, NEN5690ZGold Aviation LLC · Greenville, SCN5695DVista Air LLC · Boxborough, MAN569DBBarnes Daniel · Valparaiso, INN569JMInternational Air Services Inc Trustee · Carson City, NVN569KCross Timbers Aviation LLC · Bedford, TXN569PGSavvy Investing LLC · Greencastle, INN569SFTaylor Bruce L Jr · Irondale, ALN56AHSouthern Aircraft Consultancy Inc Trustee · Casper, WYN56APCka Investments LLC · Mcallen, TXN56BKoch & Koch Inc · Grass Valley, CAN56BMAtlas Aero LLC · Fargo, NDN56CMFamily Practice Associates LLC · Ulysses, KSN56DACirrus Design Corp · Duluth, MNN56DCAero Services Lc · Woods Cross, UTN56GKMatan Kai LLC · West Hollywood, CAN56GLRainosek Kevin · Granbury, TXN56HDouble D International LLC · Miami, FL
Back to AD 2012-10-13