AD 2012-25-01
Registered aircraft · 954
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-25-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:2012-25-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:2012-25-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:2012-25-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.
N351FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN351HDT Scott Dunn Construction Inc · Phoenix, ORN351HNDiscovery Helicopters LLC · Las Vegas, NVN351VSAlpine Air Alaska LLC · Girdwood, AKN352HDT Scott Dunn Construction Inc DBA · Phoenix, ORN352HPState Of Utah · Salt Lake City, UTN352PAPathfinder Leasing LLC · Anchorage, AKN352PDSuffolk County Police Department · Yaphank, NYN352RNs Air Leasing LLC · Wilmington, DEN352SASycan Corp DBA · Paso Robles, CAN352VHElt Holdings LLC · Cottonwood, AZN353CEAviation Advantage Inc · Tabor City, NCN353EReeder Flying Service Inc · Twin Falls, IDN353FBNs Air Leasing LLC · Wilmington, DEN353FSDiscovery Helicopters LLC · Boulder City, NVN353HPState Of Utah · Salt Lake City, UTN353JRPrecision LLC · Mcminnville, ORN353JSCedar Heights Aircraft LLC · Rhinebeck, NYN353MHPathfinder Leasing LLC · Anchorage, AKN353PPhi Health LLC · Tempe, AZN353SHSycan Corp DBA · Paso Robles, CAN354AKAris Aviation Group LLC · Boulder City, NVN354CFRegistration Pending · Greenwood Village, CORegistration pendingN354EReeder Flying Service Inc · Twin Falls, IDN354HDCsc Delaware Trust Co Trustee · Wilmington, DEN354HPState Of Utah · Salt Lake City, UTN354LASale Reported · Milton, VTSale reported, canceledN354PPhi Health LLC · Tempe, AZN354PAPathfinder Leasing LLC · Anchorage, AKN354PDSuffolk County Police Department · Yaphank, NYN354SHSycan Corp DBA · Paso Robles, CAN355AGHover-Views Unlimited Inc · Syosset, NYN355AMAir Methods LLC · Greenwood Village, CON355ARCsc Delaware Trust Co Trustee · Wilmington, DEN355CFAir Methods LLC · Greenwood Village, CON355ERElite Rotorcraft LLC · Mt Juliet, TNN355EXSolomon Mark Trustee · Wilmington, DEN355FFRichards William · Gardiner, NYN355HCAm Air Service LLC · Green Oaks, ILN355HRNext Level Aviation LLC · Pflugerville, TXN355JCMavana As LLC · Miami, FLN355NSNs Air Leasing LLC · Wilmington, DEN355RSThompson Flying Service LLC · Charleston, MON355SFHowe Aviation LLC · Surprise, AZN355THTimberland Helicopters Inc · Ashland, ORN356KJB&R Trucking Inc · Carlsbad, NMN356PPhi Health LLC · Tempe, AZN357KVKavecol Inmobiliaria Inc · Guaynabo, PRN357PAPathfinder Leasing LLC · Anchorage, AKN358PAPathfinder Leasing LLC · Anchorage, AK
Back to AD 2012-25-01