OpenAirDocs.org
AD 2005-12-20

Registered aircraft · 473

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:2005-12-20')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-12-20')
  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.

N1003XKap Electric Inc · Sulphur, LAS/N 41748N10111Psh Leasing LLC · Park City, UTS/N 41739N10222Willard Gregory M · Bonita Springs, FLBuilt 2009 · S/N 411141N1024ZAqua Men Service LLC · Temple, GABuilt 2005 · S/N 41097N10332Tx Holdings · Hermosa Beach, CABuilt 2009 · S/N 411132N1036PHeyden Aviation LLC · Alpharetta, GABuilt 2009 · S/N 411138N103PFQuality Protection Inc · Springfield, MOBuilt 2008 · S/N 411092N104PPToledo Public Schools · Swanton, OHS/N 41086N10580Dwyer Lawrence William · Berthoud, COS/N 411150N10582Horizon A Dream Inc Trustee · Wilmington, DES/N 411152N1058ZBaillie Richard Leslie · Newark, DEBuilt 2008 · S/N 411058N1087TCampagna Thomas B · Midland, TXBuilt 2008 · S/N 411033N1131KFirst Properties LLC · Medford, ORBuilt 2007 · S/N 41742N1131VPeter V Desanctis Cpa Pa · Jupiter, FLBuilt 2008 · S/N 411098N1133GGrannell Roy B · Southlake, TXBuilt 2009 · S/N 411126N1134NFls LLC · Missoula, MTBuilt 2009 · S/N 411134N11390Young Randy Jay · Spanish Fork, UTBuilt 2009 · S/N 411139N1141YHeyde Robert D · Coeur D Alene, IDBuilt 2009 · S/N 411140N1143ZVoov LLC · Dover, DEBuilt 2008 · S/N 411107N1159QPeak Aviation LLC · Salida, COBuilt 2008 · S/N 411061N1161VDesert Pine Aviation LLC · Scottsdale, AZS/N 41749N116FTGreenhill Stacey · Lincolnshire, ILBuilt 2008 · S/N 411112N1198ZExecutive Airfleet LLC · Boca Raton, FLS/N 411151N119PEDoo Me Too LLC · Spearfish, SDS/N 411043N1211DWest Ridge Ttx LLC · Parker, TXBuilt 2008 · S/N 411104N1229VSale Reported · Greeley, COSale reportedBuilt 2008 · S/N 411110N1235LN1235l LLC · Tallahassee, FLBuilt 2007 · S/N 41741N1239ZDerrickson Bryan C · Lewes, DEBuilt 2009 · S/N 411124N1241GCastanon Mike · Perryton, TXBuilt 2007 · S/N 41777N1243XAircraft Partner Holdings Inc Trustee · BerlinBuilt 2007 · S/N 41755N1253YSallee Real Estate Investments LLC · Lees Summit, MOBuilt 2009 · S/N 411133N125BTPointe Companies Inc · Silver City, NMBuilt 2009 · S/N 411125N1266PArnold Aviation Ltd · Minster, OHBuilt 2006 · S/N 41637N1266YVerona Equipment LLC · Verona, KYBuilt 2006 · S/N 41587N1268FTilted Wings LLC · Manassas, VABuilt 2006 · S/N 41648N1269DMckeage Bradley J · Melbourne, FLBuilt 2006 · S/N 41633N1271T3dg LLC · Sylva, NCBuilt 2006 · S/N 41655N12727Sunset Spas LLC · Chandler, AZBuilt 2007 · S/N 41769N1272NEastern Stearman Inc Trustee · Leesburg, VABuilt 2007 · S/N 41650N12744Esa Es Corp · Glen Cove, NYBuilt 2006 · S/N 41690N1274AAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 41762N1274XFly El Paso LLC · El Paso, TXBuilt 2008 · S/N 411077N1276LD Porter Enterprises LLC · Dickinson, NDBuilt 2006 · S/N 41651N1276ZJrjhnj Aviation LLC · Statesboro, GABuilt 2009 · S/N 411120N1278ZNew Hartford Psychiatric Services P L L C · Whitesboro, NYBuilt 2006 · S/N 41658N1280ZPlane Fun Inc Tr Trustee · Snellville, GABuilt 2007 · S/N 41654N1282DJas & Jls Holdings LLC · Lake Point, UTBuilt 2006 · S/N 41642N1282MCastaneda Carlos · Clyde Hill, WABuilt 2008 · S/N 411083N1285D6886 Aviation LLC · Mesa, AZS/N 41638N1285VCarrobby LLC · Wilmington, DEBuilt 2008 · S/N 411085
Back to AD 2005-12-20