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.
N715CDRegistered aircraftSale reportedN715CHShatkin Todd Ellis · Amherst, NYN715CRCrv Aviation LLC · Palmetto Bay, FLN715EMCloud 9 Aviators LLC · Lake Zurich, ILN715JGBz Air LLC · Lebanon, NJN715JNHerman David Trustee · Chesapeake, VAN715JPSk Air LLC · Federalsburg, MDN715JVWalton Evan · Grand Junction, CON715KWJgw Aviation I · Naples, FLN715LPN715lp LLC · Sarasota, FLN715LTTraveler LLC · Fort Stockton, TXN715MHHill Michelle · Yreka, CAN715MJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN715PT715pt LLC · Saint Petersburg, FLN715RLNofziger Medical Consulting LLC · Stryker, OHN715SRSch Aviation Inc Trustee · NorfolkN715SVSutton Scott F Trustee · Lake Stevens, WAN715WTAscend Amigos LLC · Alpine, WYN715YAKansas Aviation LLC · Lawrence, KSN715YJQuintet Capital LLC · Marysville, OHN716BLMcl Aviation LLC · Pinehurst, NCN716BSOz Fund Investments LLC · Charleston, WVN716CDSky-Vu Flyers Inc · Fishers, INN716DRT A S K Aviation LLC · Panama City Beach, FLN716JDMyers Drew E · Norton, MAN716KPSpirit Travel Air LLC · Saint Charles, MON716KTKstc Enterprises 2 LLC · Redding, CAN716PVOptimum G7 Aviation LLC · Sterling, VAN716WTSjr LLC · Helena, MTN7171XUnion Hill Aviation Inc · Wilmington, DEN717AADomfreman LLC · Kalispell, MTN717AFHelice Air LLC · Morgan Hill, CAN717AHGrace By Air LLC · Hogansville, GAN717APLone Mountain Aircraft LLC · Vandalia, OHN717BCCain Brian S · Piedmont, CAN717BDWeathered Aviation Inc · Rogers, ARN717BEColeray Aviation LLC · Powder Springs, GAN717BGRye Aviation Services LLC · Palm City, FLN717BLWeaver Air LLC · Starkville, MSN717BWAnchor Aviation LLC · Amarillo, TXN717CGContinental Title Trust LLC Trustee · Wichita, KSN717CWAmerican Flying Club Inc · Arlington, VAN717DFSb Aviation Corp · New York, NYN717DKRegistration Pending · North Las Vegas, NVRegistration pendingN717DMHbp Inc · Camp Hill, PAN717DWSmac Aviation LLC · Mountain Home, ARN717FCirrus Design Corp · Duluth, MNN717GGBoise 208 LLC · Boise, IDN717GWWtl Aviation LLC · Aurora, ORN717HSCorjenum Inc Trustee · Wilmington, DE
Back to AD 2012-10-13