AD 2002-07-01
Registered aircraft · 3,466
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:2002-07-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
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:2002-07-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01') 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.
N2591TFerguson John W · Edwardsburg, MIN25GPAir Data Solutions LLC · Natchitoches, LAN25JGCenturion Aircraft Limited · Centennial, CON25WDSale Reported · Greeley, COSale reported, canceledN2607SHunter Gary A · Fort Wayne, INN2613SLow Wing Aviation LLC · Mountain Home, ARN2616SMontana Alpha Omega Ranch LLC · Miles City, MTN262CACompass Aviation Inc · Shelby, NCN262DQIschi Phillip · Soldotna, AKN2642SReich Stephen Barry · Kentfield, CAN2656SPierini William C · Chico, CAN2667SMarcum Aviation Maintenance Services LLC · Galena, OHN2673SWilliams Randall S · Chico, CAN267LMAviation Trust Co LLC Trustee · Oklahoma City, OKN268DLCrenshaw Robert L · Goldsboro, NCN26CFKustatan Leasing LLC · Nikiski, AKN26CRSim International Inc · Fort Mill, SCN26CUAnselmo Jeffery A · Fairfield, CAN26FCRwr Air Inc · Tok, AKN26KNSky King Aviation Inc · Weslaco, TXN26PMHill Capital Leasing LLC · Scottsdale, AZN26RSStacey Enterprises Inc · Ogden, UTN26TARyan Air Inc · Anchorage, AKN270MRFurtado William J III DBA · Fremont, CAN2743JColman Scott · Tampa, FLN274HAPacific Rain Inc · Arroyo Grande, CAN275FState Of Alaska Department Of Public Safety · Anchorage, AKN276ACSmith Air Inc · Ukiah, CAN278PBP21000318 Inc Trustee · Wilmington, DEN27BSl Leasing Group LLC · Barnesville, GAN27GPFlying Colors Airparts Inc · Leesburg, FLN27SC5c Aviation LLC · Scottsdale, AZN280SWKatie Investments Inc · Little Rock, ARN2814QGill Robert L · Dixon, CAN281UDStanley David Wayne · Burleson, TXN283RDBengtson Douglas Richard · Woodinville, WAN283TBNance Joseph W · Fort Collins, CON2852SLudian Malgorzata · Bakersfield, CAN2856QFoster Aaron J · Missoula, MTN2874EMoutafian Adom · Los Gatos, CAN289KWMiner'S Outdoor Adventures LLC · Hermantown, MNN28JMWestern Aviation Services LLC · Cheyenne, WYN28LZLindemann Thomas · Gustine, CAN28RSElohim Airparts Sales LLC · Naples, FLN29000Bevins William Brian · Phoenix, AZN29002E A B Services LLC · Cape Coral, FLN29003R J Kielty Plumbing Heating And Cooling Inc · New Port Richey, FLN29011Awsm Inc · Grand Canyon, AZN29018Pacific Rim Energy Inc · Henderson, NVN2902N2902 LLC · Miami, FL
Back to AD 2002-07-01