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.

N304SGSierra Golf Aviation LLC · Albuquerque, NMBuilt 1971 · S/N 15072690 N3051VMeyette Alexzander · Montague, MIBuilt 1974 · S/N 15076370 N3053SStelling Kurt · Newnan, GABuilt 1967 · S/N 15066953 N3053XVoigt Richard D · La Vernia, TXBuilt 1966 · S/N 15064453 N3054XHeidt Daniel A · Opelika, ALBuilt 1966 · S/N 15064454 N3055XChickasha Wings Inc · Chickasha, OKBuilt 1966 · S/N 15064455 N3056XSmith Chelsea R · Louisville, KYBuilt 1966 · S/N 15064456 N3057SMcabee Patrick A · Tampa, FLBuilt 1967 · S/N 15066957 N3057XSoules William P · Las Cruces, NMFirst renewal noticeS/N 15064457 N305DWPugleasa William Hunter · Lowell, ARBuilt 1982 · S/N 15285502 N305MJRegistration Pending · Phoenix, AZRegistration pendingBuilt 1967 · S/N 15067465 N3062SRiver City Aviation LLC · Carmichael, CABuilt 1967 · S/N 15066962 N3062XReeser Peggy E · Paige, TXBuilt 1966 · S/N 15064462 N3063SLong Aaron T · Seguin, TXS/N 15066963 N3063XN3063x LLC · New Braunfels, TXBuilt 1966 · S/N 15064463 N3064SAtaee Behnam · Beatrice, NEBuilt 1967 · S/N 15066964 N3064XAldridge James M · Fairbanks, AKBuilt 1966 · S/N 15064464 N30677Worley Timothy Joseph · San Angelo, TXBuilt 1973 · S/N 15074966 N3067VStauffer Todd · Jackson, MSBuilt 1974 · S/N 15076375 N3068SZephyrhills Flying Club Inc · Tampa, FLBuilt 1967 · S/N 15066968 N3071XSmith Lawrence A · Alleyton, TXBuilt 1966 · S/N 15064471 N3072SRawson Aviation LLC · Pryor, OKBuilt 1967 · S/N 15066972 N3072VFlight Time Builders Inc · Memphis, TNBuilt 1974 · S/N 15076377 N3073SCresswell Aubrie J · Norwood, PABuilt 1967 · S/N 15066973 N3074STail Aero Corp · Wilmington, DEBuilt 1967 · S/N 15066974 N3076XOlesen Wayne O · Troy, IDBuilt 1966 · S/N 15064476 N3078XRogers Matthew J · New Paltz, NYBuilt 1966 · S/N 15064478 N3080XN3080x LLC · Greenwood Village, COFirst renewal noticeBuilt 1966 · S/N 15064480 N3081SSproul Wendell C · Hermon, MEBuilt 1967 · S/N 15066981 N3083SPrather David H · Gig Harbor, WABuilt 1967 · S/N 15066983 N3084SHigh Exposure Inc · Wilmington, DEBuilt 1967 · S/N 15066984 N3085SVilleneuve Stephane A Peltereau · Fort Worth, TXBuilt 1967 · S/N 15066985 N3089SGrafious Jon · Coventry Township, OHBuilt 1967 · S/N 15066989 N3089XNostdahl Robert W · Bottineau, NDBuilt 1966 · S/N 15064489 N308CCRobinson Earl A · Pageland, SCBuilt 1969 · S/N 15070954 N308DW8dw LLC · Glendale, CABuilt 1985 · S/N 15285940 N3090VPinkepank James A · Peachtree City, GAS/N 15076380 N3090XSills Garry D · Malakoff, TXBuilt 1966 · S/N 15064490 N3091SRempala Jill E · Saint Peters, MOBuilt 1967 · S/N 15066991 N3091XConnolly Shawn P · Chicopee, MABuilt 1966 · S/N 15064491 N3093SAdkins Dwain L · Sycamore, ILBuilt 1967 · S/N 15066993 N3093XGadler Timothy L · Lake Oswego, ORS/N 15064493 N3095SCessna 3095s LLC · Colorado Springs, COBuilt 1967 · S/N 15066995 N3097SDaj Holdings Inc · Wilmington, DEBuilt 1967 · S/N 15066997 N3097XSmall James M · Carthage, INBuilt 1966 · S/N 15064497 N3098XAnnrich Corp · Mc Lean, NYBuilt 1966 · S/N 15064498 N3099SDrury Claude R · Denton, TXS/N 15066999 N30LDPartlow David D Jr · Pahoa, HIBuilt 1966 · S/N 15063631 N3101JRobinson David N · Colleyville, TXBuilt 1966 · S/N 15065801 N3101XBlalock Bernnie R · Washington, OKBuilt 1966 · S/N 15064501

Back to AD 2009-10-09 R2