Skip to content

AD 2009-13-06 R1

Registered aircraft · 2,131

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

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:2009-13-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-13-06-R1') ORDER BY n_number

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

N31PCFlight World Inc · San Juan, PRBuilt 1958 · S/N 23-1349 N31PNRhs Consulting Ltd LLC · Reno, NVBuilt 1976 · S/N 31P-7630009 N31PRAlpha Whiskey 1 LLC · Brandon, MSBuilt 1979 · S/N 317952049 N31RCJoey Os LLC · Darlington, PAS/N 27-2818 N31RDIsland Bound LLC · Dunedin, FLS/N 31-7852059 N31TEMiller David A · Albany, ORBuilt 1984 · S/N 31-8452012 N31TUKalm Air Inc · Junction, TXBuilt 1973 · S/N 27-7305011 N31TVCornea Kevin Troy · Palm City, FLBuilt 1979 · S/N 27-7954054 N320RBLogan David J · Saint Helens, ORBuilt 1963 · S/N 27-2389 N3211PJudie Bear Air LLC · Bend, ORBuilt 1957 · S/N 23-1152 N321ACB & H Aviation LLC · Marion, KYBuilt 1974 · S/N 27-7405334 N321CCMclaughlin Ralph B · Groveland, CAS/N 277304950 N321FUTms Turboprop 2xl LLC · Wilmington, DES/N 31T-8166063 N321LBSpeer Transport LLC · El Cajon, CABuilt 1981 · S/N 31T-8166012 N321LHMullins Michael · Seaford, DEBuilt 1985 · S/N 42-5527012 N321NCArizona Air Salvage · Phoenix, AZBuilt 1977 · S/N 27-7754101 N321SJTmg Aircraft Holdings LLC · New Port Richey, FLBuilt 1977 · S/N 31-7752038 N3227PTucker Patricia A · Hamilton, MTBuilt 1957 · S/N 23-1114 N3229PRiggs Charles A · Pembroke Pines, FLBuilt 1957 · S/N 23-1172 N322SMShivers James C II · Columbus, OHS/N 27-4417 N3234LTarrant County College · Fort Worth, TXBuilt 1967 · S/N 27-3626 N323APEm Concordia Inc · Brooklyn, NYS/N 31-8252031 N323DDHd Security Systems LLC · Watertown, TNBuilt 1981 · S/N 31-8152170 N3241PBravo Partners LLC · Payson, AZBuilt 1957 · S/N 23-1186 N3248PAero Spectra Corp · Boulder, COS/N 23-1193 N324ARParrish Blake · Seminole, TXS/N 31T-7620052 N324RTTorres Rafael · Levittown, PRBuilt 1966 · S/N 27-3210 N3252PGodbout Kevin P · South Hadley, MABuilt 1957 · S/N 23-1197 N325AKInternational Air Services Inc Trustee · Carson City, NVS/N 31-8112016 N325BBCapital City Curb & Gutter LLC · Wake Forest, NCBuilt 1975 · S/N 31-7512021 N325CRDiaz Aviation LLC · South New Berlin, NYBuilt 1978 · S/N 31-7912001 N325FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N 31-8212005 N325FJSale Reported · Hopkinsville, KYSale reportedBuilt 1977 · S/N 31-7812007 N325JAdonai International Ministries · Marine, ILBuilt 1976 · S/N 31-7712002 N325LBGlobal Aircraft Trust Inc Trustee · Cheyenne, WYS/N 27-7305149 N325SGTraveling Lill LLC · Key Largo, FLBuilt 1978 · S/N 317812115 N3268POn Glideslope LLC · Middletown, DEBuilt 1957 · S/N 23-1213 N3276PFly Rite Aviation LLC · Fort Myers, FLS/N 23-1221 N3278YMiddle Tennessee State University · Murfreesboro, TNS/N 27-3714 N3279PSouth Bay Flight Training Center · Carolina, PRBuilt 1957 · S/N 23-1224 N3280PRiggin Flight Service Inc · Madison, SDBuilt 1956 · S/N 23-679 N3285PLsop Rentals Premier Asset Management LLC · Gowanda, NYBuilt 1957 · S/N 23-1233 N328RED & R Ezzell Inc · Rockwall, TXBuilt 1983 · S/N 31T-8166068 N3292PCrosswindz Ranch LLC · Seminole, TXS/N 23-1242 N3298PCross Albert B III · Salinas, CABuilt 1957 · S/N 23-1248 N329KKBristol Aircraft Leasing LLC · Montgomery, ALBuilt 1980 · S/N 31T-8104011 N329SDAce Flight Center Inc · St Thomas, VIBuilt 1966 · S/N 27-3512 N32DMHulme Thomas L · Fountain Hills, AZBuilt 1959 · S/N 23-1692 N32JDDuflo Spray Chemical Inc · Bremen, NYS/N 27-372 N32PBLease One LLC · Lafayette, INBuilt 1981 · S/N 31-8212006

Back to AD 2009-13-06 R1