AD 2012-23-01

Registered aircraft · 479

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-23-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-23-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.

N870VLCaribbean Flyers LLC · San Juan, PRBuilt 1981 · S/N 402C0616N871VLZee Enterprise Inc · Chicago, ILBuilt 1980 · S/N 402C0290N8789BBearcat Aviation LLC · Joplin, MOBuilt 1980 · S/N 414A0605N8851KJac Leasing LLC · Fort Myers, FLBuilt 1979 · S/N 414A0239N8853K8853k LLC · New Bedford, MABuilt 1979 · S/N 414A0240N890CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1978 · S/N 402C0006N89ADClairmont Holdings Vi LLC · St Thomas, VIS/N 402C0115N900SHShadowline Aviation LLC · Wilmington, DEBuilt 1979 · S/N 414A0460N902BAEcho Charlie LLC · Manvel, NDBuilt 1979 · S/N 414A-0324N903CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0047N909RFPastjo Aviation LLC · Charleston, WVBuilt 1982 · S/N 414A0840N919CBCatclaw Aviation LLC · San Antonio, TXBuilt 1981 · S/N 414A0672N919FAFortnum Air LLC · Dana Point, CAS/N 414A0628N91TWPistol Aviation LLC · Stillwater, OKBuilt 1978 · S/N 414A0117N934CRReygar Investments LLC · Brownsville, TXBuilt 1982 · S/N 414A0856N9414ARitchie Race S · Odessa, TXS/N 414A0267N94RWWithers Dana Ruth Executor · Mount Vernon, ILBuilt 1981 · S/N 414A0662N959RHRd Holdings LLC · Las Vegas, NVBuilt 1978 · S/N 414A0217N959TXAhern John · Prosper, TXBuilt 1977 · S/N 414A0011N960DFAir Services International Leasing LLC · Fort Lauderdale, FLBuilt 1979 · S/N 414A0444N97JKAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1978 · S/N 414A0052N986GMGospel Ministries International Inc · Collegedale, TNBuilt 1978 · S/N 414A0089N98CEQueen Aviation LLC · Wilmington, DEBuilt 1978 · S/N 414A0066N991AAHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0317N997JDAviation.One Business Holdings LLC · Mesa, AZBuilt 1984 · S/N 414A1004N997TAAir Flight Inc · Fort Lauderdale, FLFirst renewal noticeBuilt 1980 · S/N 402C-0231N999EUValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 414A-0233N99HJMf Property Management LLC · Hattiesburg, MSBuilt 1978 · S/N 414A0041N9NCEmpresas Marex Inc · Mayaguez, PRBuilt 1978 · S/N 414A0202
Back to AD 2012-23-01