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.

N230JCN230jc Inc Trustee · Wilmington, DEBuilt 1977 · S/N 27-7854011 N2313ZT R Gemelli Holding Co LLC · Wilmington, DEBuilt 1979 · S/N 27-8054013 N2320MAkl Properties · Westlake, OHBuilt 1979 · S/N 27-7954038 N2323MPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954039 N233PSDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N 31T-7820039 N2345RBlue Wave Air LLC · Huntsville, ALBuilt 1981 · S/N 27-8154019 N234CEAir Arctic Inc · Fairbanks, AKBuilt 1980 · S/N 31-8052203 N234PLCole Steven David · Saint Petersburg, FLS/N 31P-7300147 N2352ZPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-8054022 N235DAMarc Aircraft Holding LLC · Soldotna, AKS/N 27-582 N235JKDetert Bradley · Valparaiso, INBuilt 1963 · S/N 27-587 N2367ZBrookie Aircraft LLC · Methuen, MABuilt 1979 · S/N 27-8054027 N2377ZMatthews Grover C · Hardinsburg, KYBuilt 1979 · S/N 27-7954116 N237PCBlue Water Solutions Inc · Peachtree City, GABuilt 1981 · S/N 31T-8166045 N2380ZCopeland Medical LLC · Jonesboro, ARBuilt 1979 · S/N 27-8054031 N23ASRusso James F · Liberty, SCS/N 27-3094 N23AVJtz Aviation LLC · Wilmington, DEBuilt 1981 · S/N 27-8154003 N23FAHayes David B · Betsy Layne, KYBuilt 1960 · S/N 27-52 N23GNMidwest General And Mechanical Contractors Inc · Highland, WIS/N 23-1415 N23TACor Yan · San Juan, PRBuilt 1978 · S/N 27-7854114 N23WBQualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 27-7405281 N23WGSamson Ryan · Escondido, CABuilt 1963 · S/N 27-565 N2405MFree Flyers Avionics Inc · Kerkhoven, MNBuilt 1979 · S/N 27-7954049 N240JBMarking Kevin J · Omaha, NEBuilt 1978 · S/N 27-7854108 N2418VHart William Kirby · Springville, CABuilt 1960 · S/N 27-81 N241CFPalermo Michael S · Carter Lake, IABuilt 1957 · S/N 23-1160 N241PBTranstek International Inc · Deerfield, ILBuilt 1964 · S/N 27-2589 N241TNWilmoth Matthew L · Traverse City, MIBuilt 1979 · S/N 27-7954110 N241WFInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 31-7852073 N242GG242gg LLC · Wilmington, DEBuilt 1979 · S/N 31-7952080 N242RAJohnston Properties LLC · Garden City, KSS/N 42-8001003 N242RKBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 31-7512025 N2437MRock Full Gospel Church · Parkersburg, WVBuilt 1979 · S/N 27-7954058 N2441MBlackburn Alan Ryan II · Palm City, FLBuilt 1979 · S/N 27-7954059 N244ABParton Aviation Co LLC · Rutherfordton, NCBuilt 1979 · S/N 31T-8004015 N244RWeiser Inc · Minburn, IABuilt 1973 · S/N 27-7305025 N2454FOlson Donald C · Golovin, AKS/N 27-2666 N2458WBig Bend Outdoor Center LLC · Pittsburg, TXBuilt 1979 · S/N 31T-8004017 N245AGMummey Jose Pablo · Everett, WAS/N 27-7305187 N245JRAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1984 · S/N 425501019 N248KCracker Aviation LLC · Jupiter, FLBuilt 1975 · S/N 27-7654004 N24CKAir Travel Management LLC · Lemont Furnace, PABuilt 1975 · S/N 31-7512049 N24YCBeauchene Air II LLC · Des Moines, IABuilt 1970 · S/N 27-4551 N2501MSchwietz Thomas E Jr · Strasburg, VAS/N 27-7954068 N250AKDb Aviation Holdings Group LLC · Fort Lauderdale, FLBuilt 1979 · S/N 31-7912045 N250BDSalom Auguste G · Old Orchard Beach, MEBuilt 1965 · S/N 27-3082 N250FDTailwind Aviation Inc · Sault Sainte Marie, MIBuilt 1976 · S/N 27-7654148 N250MDInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 31-742 N250RTMatthews Aviation LLC · Hardinsburg, KYBuilt 1971 · S/N 27-4681 N250TASunset Aviation LLC · Halifax, PABuilt 1974 · S/N 27-7405364

Back to AD 2009-13-06 R1