Skip to content

AD 2009-10-09 R2

Registered aircraft · 8,565

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-10-09-R2') 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-10-09-R2') 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-10-09-R2')
    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-10-09-R2')
  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-10-09-R2')
  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-10-09-R2')
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.

N6503SElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1967 · S/N 15067303 N6504GHoward David D · Winner, SDBuilt 1970 · S/N 15072004 N6505FCoffman Curtis M · Lakeside, ORBuilt 1966 · S/N 15063105 N6505GStern Scot G · Escondido, CABuilt 1970 · S/N 15072005 N6505MUrrea Hugo Edmundo Rincon · Katy, TXBuilt 1980 · S/N 15284760 N6506FMdowell Pilot Service LLC · South Hutchinson, KSS/N 15063106 N6509LSnohomish Flying Service Inc · Snohomish, WABuilt 1980 · S/N 15284425 N6510FPrice Gregory L · Kyle, TXBuilt 1966 · S/N 15063110 N6511SGby Aero LLC · Cocoa, FLS/N 15067311 N6512GParry Anthony D · Sedro Woolley, WAS/N 15072012 N6512SHaskin Jeff · Sulphur Springs, TXBuilt 1967 · S/N 15067312 N6515GNorthwest Aeroventures LLC · Steilacoom, WABuilt 1970 · S/N 15072015 N6515SMoroney Richard D · Mc Grath, MNS/N 15067315 N6516HArmenta Javier · Douglas, AZBuilt 1979 · S/N 15284175 N6516SLee Robert E · Medford, WIS/N 15067316 N6517FSnouffer Robert E · Mountain Grove, MOBuilt 1966 · S/N 15063117 N65199Long Island Aviators LLC · Seaford, NYBuilt 1980 · S/N 15284323 N651EFGrizzly Air LLC · Clearwater, FLBuilt 1967 · S/N 15067317 N6520SHighfield Carey · Vanceburg, KYBuilt 1967 · S/N 15067320 N6521GKirk James H III · Odessa, FLBuilt 1970 · S/N 15072021 N6521QAlpha Wings Inc · Willoughby, OHBuilt 1981 · S/N 15285266 N6522SAlicandro Mark B · Sebastian, FLBuilt 1967 · S/N 15067322 N6523FMatthews Mark · Brandon, MSBuilt 1966 · S/N 15063123 N6523GLee Jay S · Granite Bay, CABuilt 1970 · S/N 15072023 N6524GSantana Eric · Lehigh Acres, FLS/N 15072024 N6525PZrelak Patrick · Apple Valley, CABuilt 1981 · S/N 15285028 N6526FHigh Exposure Inc · Wilmington, DEBuilt 1966 · S/N 15063126 N6527SHirkala Ronald R · New Cumberland, WVBuilt 1967 · S/N 15067327 N6529BCloud 9 Aviation LLC · Scenery Hill, PAS/N 15283944 N6529FRising Aviation LLC · Prairieville, LABuilt 1966 · S/N 15063129 N6529SDemott Steve · Covina, CAS/N 15067329 N6530FRaw Racing Inc · Puyallup, WABuilt 1966 · S/N 15063130 N6531GGalavis Eduardo · Miami, FLBuilt 1970 · S/N 15072031 N6531SHatcher Mark F · Aloha, ORBuilt 1967 · S/N 15067331 N6533FMoore William H III · Deer Park, WABuilt 1966 · S/N 15063133 N6534FAnderson Ted E · Petal, MSBuilt 1966 · S/N 15063134 N6534LAndreassen Andrew R · Pleasanton, NEBuilt 1980 · S/N 15284428 N6535S315 Flight Club LLC · Fulton, NYBuilt 1967 · S/N 15067335 N6536GMessersmith Brian W · Grand Prairie, TXS/N 15072036 N6536PWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 15285029 N6536SSohr Brian S · Oconto, WIBuilt 1967 · S/N 15067336 N6537GShettel Jay E · Boiling Springs, PAS/N 15072037 N65398Seeley Timothy C Trustee · Chico, CABuilt 1978 · S/N 15281526 N6539FSweitzer Merle E · Felton, PABuilt 1966 · S/N 15063139 N6539GSchneider Joel · Champaign, ILBuilt 1970 · S/N 15072039 N65401Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1978 · S/N 15281529 N65407Clemson Flying Club Inc · Seneca, SCS/N 15281533 N65408Hendrix Aviation Inc · Plantation, FLBuilt 1978 · S/N 15281534 N6540GKultti Richard O · Sonoma, CABuilt 1970 · S/N 15072040 N6540SHalverson Jan T · Goldendale, WABuilt 1967 · S/N 15067340

Back to AD 2009-10-09 R2