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.

N855TWMapes Peter B · Oscoda, MIS/N 15065657 N8561GFox Harvey · Lititz, PABuilt 1965 · S/N 15062661 N8563JTschepen Leo R · Bisbee, NDBuilt 1967 · S/N 15066463 N8565GFreedom Flight Service LLC · Glendale, AZBuilt 1965 · S/N 15062665 N8566GEluwawalage Damayanthie · Reading, PABuilt 1966 · S/N 15062666 N8568GSkeen Harry K · Philippi, WVBuilt 1966 · S/N 15062668 N856DASpanaflight LLC · Puyallup, WABuilt 1980 · S/N 15284377 N8570GGreenville Pilots Association Eaa Chapter 1382 · Greenville, ILS/N 15062670 N8570JBitikofer Brent · Kansas City, KSS/N 15066470 N8571JRoam Gary A · Venice, FLBuilt 1967 · S/N 15066471 N8572USkyline Aviation Solutions LLC · Grosse Ile, MIBuilt 1976 · S/N 15077952 N8573GFichtner Eric Lowell Russell · Concord, NCS/N 15062673 N8574JHubenthal William L · Carbondale, ILBuilt 1967 · S/N 15066474 N8575GAero Services Lc · Woods Cross, UTS/N 15062675 N8576GSchaefer John · Liberty Hill, TXBuilt 1966 · S/N 15062676 N8577GLakey Robert E · Arlington, TXBuilt 1965 · S/N 15062677 N8578JParagon Aviation LLC · Reading, PABuilt 1967 · S/N 15066478 N857ERAlpha International Aircraft Inc · Lewes, DES/N 15282420 N8580GRhoat William E · Paso Robles, CAFirst renewal noticeBuilt 1965 · S/N 15062680 N8582JMarchione Laverne R · Diamondville, WYBuilt 1967 · S/N 15066482 N8584JDarrach Todd I · Rhome, TXBuilt 1967 · S/N 15066484 N8585GCollins Terry R · Lewistown, ILBuilt 1965 · S/N 15062685 N8587JMorgan Jeffrey E · Peebles, OHBuilt 1967 · S/N 15066487 N8588GTulsa Technology Center School Dist No 18 · Tulsa, OKBuilt 1965 · S/N 15062688 N8588JLyons Donald F · Cheverly, MDFirst renewal noticeBuilt 1967 · S/N 15066488 N8589GRay Clinton R · Brighton, MIBuilt 1965 · S/N 15062689 N8590GAsher Charles S · Grosse Ile, MIBuilt 1965 · S/N 15062690 N8590USunrise Legacy Aviation LLC · Corona Del Mar, CABuilt 1976 · S/N 15077955 N8595GLazy 8 Flying Service LLC · Polson, MTBuilt 1965 · S/N 15062695 N8596JNelson David D · Mercer, PABuilt 1966 · S/N 15066496 N8599GBoatright Michael L · Live Oak, FLBuilt 1966 · S/N 15062699 N85FASilver Express Co DBA · Miami, FLBuilt 1980 · S/N 15283865 N85SSCornelius John W · Elgin, TXBuilt 1966 · S/N 15064568 N8600GHunter Brian D · Scranton, IAFirst renewal noticeBuilt 1965 · S/N 15062700 N8600UCristiano Thomas J · Clifton Park, NYBuilt 1976 · S/N 15077957 N8601GRamakrishna Murali DBA · Burlington, MABuilt 1966 · S/N 15062701 N8601SDykstra Wayne A · Pipestone, MNS/N 15061901 N8604JPouncey Wayne · Merced, CAFirst renewal noticeBuilt 1967 · S/N 15066504 N8605GPhelps John W · Spring Hill, FLBuilt 1965 · S/N 15062705 N8606JMaedgen Gary W · Voss, TXS/N 15066506 N8606SFlight Time Builders Inc · Memphis, TNBuilt 1965 · S/N 15061906 N8607GShooting Star Museum · Devine, TXBuilt 1965 · S/N 15062707 N8608JWalker Rhan E · Pleasant Hill, MOBuilt 1967 · S/N 15066508 N8609GCourt Amy L · Staatsburg, NYBuilt 1965 · S/N 15062709 N8610ZJayviation Inc · Lake City, FLS/N 15065108 N8612GN8612g LLC · Orangeburg, SCBuilt 1965 · S/N 15062712 N8613SHanna Michael · Foristell, MOBuilt 1965 · S/N 15061913 N8614GShah Jawad A · Spring, TXBuilt 1965 · S/N 15062714 N8614JMoles Dale A · Mooresburg, TNBuilt 1967 · S/N 15066514 N8617SFrasch Randy D · Missoula, MTBuilt 1965 · S/N 15061917

Back to AD 2009-10-09 R2