Skip to content

AD 2009-13-06 R1

Registered aircraft · 2,130

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.

N52TTMinuteman Aviation Inc · Missoula, MTBuilt 1979 · S/N 31T-7920057 N52WWPacific Fleet Aviation LLC · Rochester, NYBuilt 1981 · S/N 27-8154014 N530JBAir Transport Services Inc · Tarpon Springs, FLS/N 31-7952156 N5317YBaker Avery R · Bonifay, FLBuilt 1963 · S/N 27-2394 N5320YRawareo LLC · Warsaw, MOBuilt 1963 · S/N 27-2397 N5329YFlying Fish Ranch 29y LLC · Leesburg, FLBuilt 1963 · S/N 27-2406 N532SJohnson Lucas G · Pleasant Lake, MIBuilt 1965 · S/N 27-2966 N533KCTidd Scott · Reading, MIBuilt 1963 · S/N 27-2390 N533YABb Aero Works Ltd · Whitehouse, OHBuilt 1968 · S/N 31-157 N5344YMerced County Mosquito Abatement District · Merced, CABuilt 1963 · S/N 27-2418 N5359YMajeste Air LLC · Loveland, COBuilt 1963 · S/N 27-2432 N5363YThompson Frank L · Weiser, IDBuilt 1963 · S/N 27-2437 N5386YKunka Michael A · Lincoln Park, MIBuilt 1963 · S/N 27-2459 N5391YHeartland Aviation Inc · Alliance, NEBuilt 1963 · S/N 27-2467 N53ACPacific Fleet Aviation LLC · Rochester, NYS/N 27-7654146 N53MCGulf Air Aviation Inc · Wilmington, DEBuilt 1978 · S/N 31T-7820025 N53TAIndiana Paging Network Inc · La Porte, INBuilt 1978 · S/N 31T-7820083 N54004Sobey Peter L · Aurora, OHBuilt 1974 · S/N 27-7405354 N5406YKillam Rodney A · Carlinville, ILBuilt 1963 · S/N 27-2481 N54072Dewitt Gary D · Encinitas, CABuilt 1974 · S/N 27-7405382 N54075Pilot Pros Inc · Miami, FLBuilt 1974 · S/N 27-7405385 N54077Geo Mar Co Aviation Ltd · Clyde, OHBuilt 1974 · S/N 27-7405389 N54089Island Birds Inc · St Thomas, VIBuilt 1974 · S/N 27-7405390 N54092Harper-Smith Michael · Tarzana, CABuilt 1974 · S/N 27-7405405 N54097Piper Nia 1 LLC · Doylestown, PABuilt 1974 · S/N 27-7405408 N54109Gilmores Glorious Goods LLC · Lewes, DEBuilt 1974 · S/N 27-7405421 N54155Aerospace Trust Management LLC Trustee · Wilmington, DES/N 27-7405452 N54195Decruz Peter John · Hattiesburg, MSBuilt 1974 · S/N 27-7405472 N54198Valiair Lc Trustee · Casper, WYS/N 27-7405474 N54221Emission-Air Inc · Lexington, NCBuilt 1974 · S/N 27-7554014 N54224Coosa Air LLC · Rome, GABuilt 1974 · S/N 27-7554017 N54225Jpr Capital LLC · San Juan, PRBuilt 1974 · S/N 27-7554018 N54236B & R Aircraft LLC · Wadsworth, OHBuilt 1974 · S/N 27-7554030 N54238Backcreek Farms Inc · Rougemont, NCBuilt 1974 · S/N 27-7554032 N54240Pacific Fleet Aviation LLC · Rochester, NYBuilt 1974 · S/N 27-7554034 N54245Pacific Fleet Aviation LLC · Rochester, NYBuilt 1974 · S/N 27-7554039 N54258Nesbeda Peter J · Marlborough, NHBuilt 1974 · S/N 27-7554046 N543133seaslal LLC · Lakeland, FLBuilt 1974 · S/N 31-7405439 N5431YThompson Sherrel L · Pembroke Pines, FLBuilt 1964 · S/N 27-2508 N5437YHayman Russell P · Ocean City, MDS/N 27-2514 N543JCBritshaw LLC · Lansdale, PABuilt 1977 · S/N 31-7752103 N543SBBielder Street Aviation LLC · North Charleston, SCBuilt 1979 · S/N 31-7912034 N5447YAnderson Michael W · Wayzata, MNBuilt 1964 · S/N 27-2528 N54504Castor Care LLC · Mount Pleasant, SCS/N 27-3369 N5454YMatthews Grover · Fairborn, OHBuilt 1964 · S/N 27-2539 N545RKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1977 · S/N 31T-7720064 N54621Atlantic Resources Of Miami Inc · Deland, FLS/N 27-7554036 N5470YWeber Mark J · Dalton, MABuilt 1964 · S/N 27-2560 N54757Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554068 N54772Watts John J · Murchison, TXBuilt 1975 · S/N 27-7554080

Back to AD 2009-13-06 R1