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.

N25476Rf Aero LLC · Plainfield, ILBuilt 1977 · S/N 15280680 N25477Mason Harold T · Hesperia, CAS/N 15280681 N25480Freeflight Aviation LLC · Allentown, NJBuilt 1977 · S/N 15280684 N25497Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280695 N25502Hartman Dylin Erik · Ray City, GABuilt 1977 · S/N 15280698 N25514Renner Thomas J · Williston, NDS/N 15280708 N25517Suski Jeanne M · Tonawanda, NYBuilt 1978 · S/N 15280710 N25518Prather David W · Cameron Park, CABuilt 1977 · S/N 15280711 N25525Ferguson Carrie L · Palo Alto, CABuilt 1977 · S/N 15280716 N25557All Aviation Xp LLC · Parkland, FLBuilt 1977 · S/N 15280729 N25564Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280732 N25567Ellingwood Kevin J · Williamstown, MABuilt 1977 · S/N 15280735 N25572Gruetzmacher Marcus Darren · Goliad, TXBuilt 1977 · S/N 15280738 N25573Adjoodani Farhad F · Glen Burnie, MDBuilt 1977 · S/N 15280739 N25575Pierce John S · Delevan, NYBuilt 1977 · S/N 15280741 N25582Heavy Metal Air LLC · Farmingdale, NYBuilt 1977 · S/N 15280746 N255EWollak John M · Mount Vernon, WABuilt 1976 · S/N 15078149 N25604Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1977 · S/N 15280762 N25608Smith Boyd · Goshen, INBuilt 1977 · S/N 15280764 N25610Painter Bryan · Renton, WABuilt 1977 · S/N 15280766 N2572LBuick Robin B · Redding, CABuilt 1973 · S/N A1500485 N25754Jet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15280767 N25772Arnold Jonathan L · Warrensburg, MOBuilt 1977 · S/N 15280774 N25773Solberg Avn Co Inc · Whitehouse Station, NJBuilt 1977 · S/N 15280775 N25775Van Es Mark E · Laredo, TXBuilt 1977 · S/N 15280777 N25779Eads James · Saginaw, TXBuilt 1977 · S/N 15280780 N25785Iggy Enterprises LLC · Gig Harbor, WABuilt 1977 · S/N 15280783 N25807Peabody Jeffery L · Vinemont, ALBuilt 1977 · S/N 15280793 N25820Sale Reported · Xxx, OKSale reportedBuilt 1977 · S/N 15280799 N25836Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280808 N25852Griffith Aviation Inc · Griffith, INBuilt 1977 · S/N 15280817 N25855Williams Stephen W · Granbury, TXBuilt 1977 · S/N 15280820 N25860Sorbi Aviation Inc · El Cajon, CABuilt 1977 · S/N 15280825 N25890Henry Mark A · Dickinson, TXS/N 15280837 N25899Ace Aircraft Leasing Inc · Nazareth, PABuilt 1977 · S/N 15280842 N25907Bishop Kenneth P · Griffin, GABuilt 1977 · S/N 15280849 N25914Aces High Aviation LLC · Long Beach, CABuilt 1977 · S/N 15280854 N25918Wichita Area Technical College · Wichita, KSBuilt 1977 · S/N 15280857 N25922Byrd-Pettit Caroline A · Smithfield, NCS/N 15280859 N25932California In Nice Inc · San Jose, CABuilt 1977 · S/N 15280864 N25948Indiana State University · Terre Haute, INBuilt 1977 · S/N 15280875 N25950Gist Phillip C · Fort Worth, TXBuilt 1977 · S/N 15280877 N25976Skylogix Aircraft LLC · La Verne, CAS/N 15280890 N25979Andrews University · Berrien Springs, MIS/N 15280892 N25995Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280903 N25998Carlin Delbert J · Blanchard, OKS/N 15280905 N25EFXin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 15280552 N25HTTobler Hans P · Anchorage, AKS/N 15281787 N2608JDriftless Aero LLC · Montfort, WIBuilt 1966 · S/N 15065608 N2609GRegistration Pending · Grove City, PARegistration pendingS/N 15077218

Back to AD 2009-10-09 R2