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.

N757JYBreuer Lisa M · Horseshoe Bend, IDBuilt 1977 · S/N 15279788 N757KFBob Hoover Academy · Salinas, CABuilt 1977 · S/N 15279795 N757KMClover Park Technical College · Tacoma, WABuilt 1977 · S/N 15279801 N757KXDamian Davis Construction Co · Candler, NCBuilt 1977 · S/N 15279811 N757LBSwaney Brian W · Pendleton, SCBuilt 1977 · S/N 15279815 N757LGMamet Oren · Andover, MABuilt 1977 · S/N 15279820 N757LMYeary Clifton K · Quitaque, TXBuilt 1977 · S/N 15279825 N757LNWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279826 N757LPPrice Thomas E · Ogden, UTFirst renewal noticeBuilt 1977 · S/N 15279827 N757LXSt Louis Flight Training LLC · Cahokia, ILBuilt 1977 · S/N 15279835 N757LYHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279836 N757MGOhio Gypsum Floors LLC · Westerville, OHBuilt 1977 · S/N 15279844 N757MMDsr-Cherokee 180 LLC · Dallas, TXBuilt 1977 · S/N 15279849 N757MPAvcorp Holdings Inc · Jackson, MIBuilt 1977 · S/N 15279851 N757MSAngel Aviation Inc · Peoria, AZS/N 15279854 N757MYStaley Grady R · Liberty, NCBuilt 1977 · S/N 15279860 N757NGWeisman Craig A · Falls Of Rough, KYBuilt 1977 · S/N 15279868 N757NJSpace Coast Aircraft Co · Merritt Island, FLBuilt 1977 · S/N 15279870 N757NNCarton David M · Claremont, NHBuilt 1977 · S/N 15279874 N757NQA&R Aero LLC · Sacramento, CABuilt 1977 · S/N 15279876 N757PMKaiser Gavin · Peachtree City, GAS/N 15279896 N757PPFields Joseph H · Placerville, CABuilt 1977 · S/N 15279898 N757PTPavlock Russell H · Tinley Park, ILBuilt 1977 · S/N 15279902 N757QBHutchison William B · Canton, OKBuilt 1977 · S/N 15279910 N757QHWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279916 N757QJWaters Thomas J · Hampton, GABuilt 1977 · S/N 15279917 N757QQKostelecky Scott J · Decatur, TXBuilt 1977 · S/N 15279923 N757RATorello Marty A · Port Huron, MIBuilt 1978 · S/N 15279933 N757RLRudak Phillip Richard · East Hartford, CTBuilt 1977 · S/N 15279943 N757RNSky Aviation & Maintenance Inc · Wildomar, CAS/N 15279945 N757RPBoyne Valley Flyers Club Inc · Boyne Falls, MIBuilt 1977 · S/N 15279946 N757RTEnright Darren R · Lakeville, MNBuilt 1977 · S/N 15279950 N757RZCox Derrell L · Pamplico, SCS/N 15279956 N757SCHicks Byron · Manchaca, TXBuilt 1977 · S/N 15279959 N757SDYu Hermon Lemuel C · Mays Landing, NJBuilt 1977 · S/N 15279960 N757STChester Charter Inc · Chester, CTBuilt 1977 · S/N 15279974 N757SWSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1977 · S/N 15279977 N757TAHofmeister Laurence C · Punta Gorda, FLBuilt 1977 · S/N 15279981 N757TDNew Horizon Aviation Inc · Warwick, RIBuilt 1977 · S/N 15279984 N757THGoodrich Pilot Training Center LLC · Johnson City, NYBuilt 1977 · S/N 15279988 N757TLSky Candy LLC · Scottsdale, AZBuilt 1977 · S/N 15279991 N757TVTri County Rentals And Sales Inc · Lake City, FLBuilt 1977 · S/N 15280000 N757UDDau Anuar · Colfax, NCBuilt 1977 · S/N 15280007 N757UFAviation Capital Management LLC · San Jose, CABuilt 1977 · S/N 15280009 N757URRichmor Aviation Inc · Hudson, NYBuilt 1977 · S/N 15280018 N757UTIfly LLC · Wichita, KSBuilt 1977 · S/N 15280020 N757UZCoulliette Brian K · Jacksonville, FLBuilt 1977 · S/N 15280026 N757VAStoup Lyndal K · Cordell, OKS/N 15280027 N757VBGanesh Prabhandhakavi · Cerritos, CABuilt 1977 · S/N 15280028 N757VVTechnical Education Services Inc T/A · Virginia Beach, VAS/N 15280046

Back to AD 2009-10-09 R2