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.

N3816JJames Randy C · Knob Noster, MOBuilt 1966 · S/N 15065116 N3818JAyresouth Aviation Inc · Lithia Springs, GAS/N 15065118 N3820VShalom Aviation LLC · Miami, FLS/N 15076633 N3824JBalcsik Christopher A · Tehachapi, CABuilt 1966 · S/N 15065124 N3827JCollins Camden B · Millersport, OHFirst renewal noticeS/N 15065127 N3834JRegistration Pending · Buckeye, AZRegistration pendingBuilt 1966 · S/N 15065134 N3835JSkylane Lift LLC · Cheboygan, MIBuilt 1966 · S/N 15065135 N3843JN3843j LLC · San Antonio, TXS/N 15065143 N3847JEscue James C · Brownsville, TNBuilt 1966 · S/N 15065147 N3849JGamble Marty · Crofton, KYBuilt 1966 · S/N 15065149 N3855JWiley Phillip W · New Martinsville, WVBuilt 1966 · S/N 15065155 N3856JClifton Chad R · Asheboro, NCBuilt 1966 · S/N 15065156 N3858VMission Aviation LLC · Orange Park, FLBuilt 1975 · S/N 15076637 N3859JOnefiftyjuliet LLC · Saint Petersburg, FLBuilt 1966 · S/N 15065159 N3859VK3 Safe Air LLC · Mokena, ILBuilt 1975 · S/N 15076638 N385PMurphy Patrick · Brooksville, FLBuilt 1978 · S/N 15281108 N385SEJensen Aviation Inc · Zephyrhills, FLBuilt 1978 · S/N 15282997 N3862JDoyle Ethan Mackenzie · Nunda, NYBuilt 1966 · S/N 15065162 N3865JAlbert Bruce F · Dallas, TXBuilt 1966 · S/N 15065165 N3867JOmura Alexander K · Missoula, MTBuilt 1966 · S/N 15065167 N3870JLucido Frank · Vacaville, CABuilt 1966 · S/N 15065170 N3875VBlaedow Kyle R · North Pole, AKBuilt 1975 · S/N 15076643 N3877JWilson Steven J · Elkton, KYBuilt 1966 · S/N 15065177 N3879JMuehl John M · Maryland, NYBuilt 1966 · S/N 15065179 N3882JPeek James · South Fork, COBuilt 1966 · S/N 15065182 N3888JAzalea Aviation LLC · Quitman, GABuilt 1966 · S/N 15065188 N3889JVeduccio Gary Robert · Griffin, GABuilt 1966 · S/N 15065189 N388SESunset Eagle Aviation LLC · Southport, FLBuilt 1968 · S/N 15068466 N3896JKhatz Rahm · Austin, TXBuilt 1966 · S/N 15065196 N38SURiverside Flight Center Inc · Tulsa, OKBuilt 1981 · S/N 15285144 N38TDLewis Brian D · Bumpass, VAS/N 15073098 N38WTReed Brian A · Kilgore, TXBuilt 1969 · S/N 15071384 N3901CAero II Inc · Spartanburg, SCBuilt 1968 · S/N 15069096 N3901JHolladay Leonard · Greeley, COBuilt 1966 · S/N 15065201 N3902CRegistration Pending · Post Falls, IDRegistration pendingBuilt 1968 · S/N 15069101 N3902JUltimate Aviation LLC · Lowell, ARBuilt 1966 · S/N 15065202 N3904VObloy James J · Brunswick, OHBuilt 1975 · S/N 15076649 N3905CWind Walker LLC · Tucson, AZBuilt 1968 · S/N 15069294 N3908JSpanaflight LLC · Puyallup, WAS/N 15065208 N390DMGurrola Joseph C · Redlands, CABuilt 1969 · S/N 15070334 N3910JNishikawa David H · Davis, CABuilt 1966 · S/N 15065210 N3913JGecsey Sandor · Budd Lake, NJBuilt 1966 · S/N 15065213 N3916JTrimble Aviation Services LLC · Atlanta, GABuilt 1966 · S/N 15065216 N3918JPegasus Horse LLC · Las Vegas, NVBuilt 1966 · S/N 15065218 N3922JPettit Thomas N · Whitestown, INS/N 15065222 N3924JRagsdale Ryan J · Hemingford, NES/N 15065224 N3935JMcdonald Patrick L · Ventura, CABuilt 1966 · S/N 15065235 N3936VRyden LLC · Goodyear, AZBuilt 1975 · S/N 15076658 N3937JWolsey Brandon S · Chino Hills, CABuilt 1966 · S/N 15065237 N3938JPlainwell Aviation And Stem Academy · Kalamazoo, MIBuilt 1966 · S/N 15065238

Back to AD 2009-10-09 R2