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.

N61168Sherwood Ronald R · Kathleen, GABuilt 1969 · S/N 15070854 N6116GWilbur David W · Marlow, NHBuilt 1969 · S/N 15071616 N61172Celeste Nash · Vista, CAS/N 15070858 N61176Closson Dennis L · Red Wing, MNBuilt 1969 · S/N 15070862 N61177Spenner John T · Fenton, MOBuilt 1969 · S/N 15070863 N61178Seman Kenneth H · Ravenna, OHBuilt 1969 · S/N 15070864 N6117MFayette Hawks Flying Club Inc · Somerville, TNBuilt 1980 · S/N 15284625 N61182B2 W Corporation · Winona, MNBuilt 1969 · S/N 15070867 N61184Lawson Gary R · Olympia, WAS/N 15070869 N61186Petit Leon · Virgil, ILBuilt 1969 · S/N 15070871 N61187Registration Pending · Burleson, TXRegistration pendingBuilt 1969 · S/N 15070872 N61189Orr Jeffrey N · Waco, TXBuilt 1969 · S/N 15070874 N61190Freed Richard H · Watervliet, MIBuilt 1969 · S/N 15070875 N61192Possemato Domenic · Lincoln, NHS/N 15070877 N611JFKeller Robert W · Racine, WIS/N 15077427 N611KHWolf Ronald T · Abbeville, LAS/N 15074824 N61205Lockhart Aero LLC · Austin, TXBuilt 1969 · S/N 15070886 N61206Hahlbohm Jeffrey S · Helena, MTS/N 15070887 N61207Desroches John · Scottsdale, AZS/N 15070888 N61208Cutone Ronald J · Old Saybrook, CTBuilt 1969 · S/N 15070889 N6120FHickman Robert J · Canby, ORBuilt 1973 · S/N A1500421 N6120KArico James A · Lisbon, CTBuilt 1975 · S/N 15077535 N61212Cole Lauren · Rockford, MIS/N 15070890 N61213Madrigal Francisco Javier · Newman, CABuilt 1969 · S/N 15070891 N61215Moody Bible Institute Of Chicago · Spokane Valley, WABuilt 1969 · S/N 15070892 N6121GMckinney Christopher D · Statesville, NCBuilt 1969 · S/N 15071621 N61221Lang Christopher S · Genoa, NVBuilt 1969 · S/N 15070896 N61229Rivera Carlos A · Beach Park, ILBuilt 1969 · S/N 15070902 N6122KKidd Robert Lee · Logan, UTBuilt 1975 · S/N 15077536 N61231US Flight Academy International Inc DBA · Post, TXBuilt 1969 · S/N 15070904 N61232East Bay Trading Company LLC · Fairview, PABuilt 1969 · S/N 15070905 N61233Advanced Aviation LLC · Kapolei, HIBuilt 1969 · S/N 15070906 N61234Registered aircraftBuilt 1969 · S/N 15070907 N6123GBoes Corey · Fostoria, OHBuilt 1969 · S/N 15071623 N61243Rios Leah F · Anchorage, AKBuilt 1969 · S/N 15070913 N61244Smith Rex M · Marshfield, MOS/N 15070914 N61251Chickasha Wings Inc · Chickasha, OKBuilt 1969 · S/N 15070916 N61253Flight Gate LLC · Wilton, CAS/N 15070918 N61259Lund Michael J · Poulsbo, WABuilt 1969 · S/N 15070924 N6125BBv Road And Site LLC · Penfield, NYBuilt 1979 · S/N 15283904 N61282Trimble David G · Vici, OKBuilt 1969 · S/N 15070939 N61286Houseman Jeffery D · Millersville, MOBuilt 1966 · S/N 15063430 N61288Vanorman Curt M · Clarkesville, GABuilt 1969 · S/N 15070944 N61296Coomes Scott F · Seattle, WABuilt 1969 · S/N 15070947 N61297Highway Jet League Flyers Brotherhood LLC · Allouez, WIBuilt 1969 · S/N 15070948 N6129GPeters William E · Bel Air, MDBuilt 1970 · S/N 15071629 N6129KLatrobe Aviation Enterprises LLC · Youngstown, PABuilt 1975 · S/N 15077538 N612CAOmni Aero LLC · Wilkesboro, NCBuilt 1978 · S/N 15282495 N6130MKing Mike · Webster, TXFirst renewal noticeBuilt 1980 · S/N 15284627 N61311Wood James A · Madera, CABuilt 1969 · S/N 15070955

Back to AD 2009-10-09 R2