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.

N46748Roscioli Lamberto · Lighthouse Point, FLBuilt 1978 · S/N 15283098 N4674XSaunders Christopher · Lehighton, PABuilt 1966 · S/N 15064724 N4675XBlalock Merrel K III · Mayflower, ARS/N 15064725 N46762Kay Bennie L · Brigham City, UTBuilt 1978 · S/N 15283102 N4677XBaird Harvey L · Sharon, OKFirst renewal noticeS/N 15064727 N4679XVentura Joel · Andover, MABuilt 1966 · S/N 15064729 N46803Ken Graham Phd Inc · Sioux Falls, SDBuilt 1979 · S/N 15283108 N46826Registration Pending · Tampa, FLRegistration pendingBuilt 1979 · S/N 15283114 N46854Phillips Joe Christopher · Grand Prairie, TXBuilt 1979 · S/N 15283121 N4685XFite Robert G · Brookings, SDBuilt 1966 · S/N 15064735 N4686LGlenn Roger H · Pacifica, CABuilt 1980 · S/N 15284216 N46889Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283133 N4688XMather Paul L · Saint Elmo, ALBuilt 1966 · S/N 15064738 N4689XGerard Aircraft Inc · Johnson, KSBuilt 1966 · S/N 15064739 N46907Bagamaspad Alan Antonio · Los Angeles, CABuilt 1979 · S/N 15283137 N4692XMelvin Jet · Bedford, INS/N 15064742 N46953Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1979 · S/N 15283149 N46964Simsbury Aviation Services LLC · Simsbury, CTBuilt 1979 · S/N 15283152 N4696XAval Aviation LLC · Las Vegas, NVBuilt 1966 · S/N 15064746 N46CAEnglehart James C · Marietta, GABuilt 1969 · S/N 15070135 N4700XCerasia Steven S · Amsterdam, NYBuilt 1966 · S/N 15064750 N47028My Way Aviation LLC · Weston, FLS/N 15283159 N47029Geronimo Aviation LLC · Scottsdale, AZBuilt 1979 · S/N 15283160 N4702PWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284801 N4704HWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 15283966 N4704XHighsmith Michael D · Chipley, FLBuilt 1966 · S/N 15064754 N47053Semagin Arkadi · Burlingame, CABuilt 1979 · S/N 15283163 N4705HWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 15283967 N4705QWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 152-85053 N4706XKey Joseph E · Eltopia, WABuilt 1966 · S/N 15064756 N4707LJet & Rotor Aviation LLC · Sacramento, CABuilt 1980 · S/N 15284222 N470EHKirkwood Aeronautics LLC · Bicknell, INBuilt 1976 · S/N 15077831 N47108Ace Aircraft Leasing Inc · Nazareth, PABuilt 1979 · S/N 15283170 N4711BPinnacle Aviation Services Inc · Encinitas, CABuilt 1979 · S/N 15283591 N4711LWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284223 N47120Shipe Jacqueline M · Louisville, TNBuilt 1979 · S/N 15283174 N4712XBludorn Matthew R · Bryan, TXBuilt 1966 · S/N 15064762 N47133Sunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15283178 N4713BSmith Peter J · Excelsior, MNBuilt 1979 · S/N 15283593 N4714XHoffman Zachariah M T · Glendale, AZBuilt 1966 · S/N 15064764 N4715XBlair Ross Iain · Milford, NJBuilt 1966 · S/N 15064765 N4717BCoastal Flight Inc · Tierra Verde, FLBuilt 1979 · S/N 15283595 N47189Xclusive Level Aircraft World LLC · Kissimmee, FLS/N 15283183 N4718AQuinby Gary D Trustee · Ardmore, OKBuilt 1979 · S/N A1520880 N4718XRobb James W · Uhrichsville, OHBuilt 1966 · S/N 15064768 N47193Cloud Dancer Aviation Inc · Deland, FLBuilt 1979 · S/N 15283185 N4720BAffiliated Air Services Inc · Vincentown, NJBuilt 1979 · S/N 15283596 N4721BEuro 2000 Inc · Merritt Island, FLBuilt 1979 · S/N 15283597 N4723BEuro 2000 Inc · Merritt Island, FLBuilt 1979 · S/N 15283598 N4723PChristiansen Aviation LLC · Wilmington, DEBuilt 1980 · S/N 15284804

Back to AD 2009-10-09 R2