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.

N45341Taylor Robert S · Satsuma, ALS/N 15076857 N45342Skybound Aviation LLC · Bixby, OKBuilt 1975 · S/N 15076858 N45350Kelley Konrad E · Grant Valkaria, FLS/N 15076863 N45351Dallas Permian LLC · Mckinney, TXBuilt 1975 · S/N 15076864 N45361Price Gregory D · Frankfort, ILBuilt 1975 · S/N 15076874 N45364Boren James Mason · Jasper, ALBuilt 1975 · S/N 15076876 N45375Eastern Slope Aviation Academy · North Conway, NHBuilt 1975 · S/N 15076885 N45376Jones Sharon J · Faulkton, SDFirst renewal noticeBuilt 1975 · S/N 15076886 N45393Currie Grant · Hermosa Beach, CABuilt 1975 · S/N 15076900 N45395Holmgren Michael G · Kulm, NDBuilt 1975 · S/N 15076902 N45398Tundra Wolf Inc · King Salmon, AKFirst renewal noticeS/N 15076905 N45407Westrup Gregory W · Greensburg, INBuilt 1975 · S/N 15076908 N45430Coffield Alan B · Canyon Lake, CABuilt 1975 · S/N 15076915 N45434Urban Aviation Services Inc · Paxton, MABuilt 1975 · S/N 15076917 N45446Coronel Juan M · Elk Grove, CAS/N 15076924 N45449Beckett Michael O · Roy, WAS/N 15076927 N45454Aero Flight One LLC · Peoria, AZBuilt 1975 · S/N 15076930 N45459Quirk Charles Leo · Lake Charles, LAS/N 15076934 N45467Airnolimits LLC · Palm Coast, FLBuilt 1975 · S/N 15076939 N45471Verhoeven Mathew M · Avondale, AZBuilt 1975 · S/N 15076941 N45473N2flyingaviation LLC · Foxworth, MSBuilt 1975 · S/N 15076942 N45478Unertl Robert C · Columbus, WIBuilt 1975 · S/N 15076946 N45491Birdwin LLC · Buras, LABuilt 1975 · S/N 15076951 N45496B&R Aircraft LLC · Wadsworth, OHS/N 15076952 N45510Hansen Albert C · Mojave, CABuilt 1975 · S/N 15076954 N45511Sb Aviation LLC · Gowanda, NYBuilt 1975 · S/N 15076955 N45512Caponio & Sons Inc · San Francisco, CABuilt 1975 · S/N 15076956 N45520Frazier John C · Oxford, NCBuilt 1975 · S/N 15076958 N45530Young Thomas E Jr · Alton, MOBuilt 1975 · S/N 15076962 N45541Zxtair LLC · Mankato, MNFirst renewal noticeBuilt 1975 · S/N 15076966 N45542Baldridge Steven J · Edmonds, WAS/N 15076967 N45560Johnson Adam · Denton, TXBuilt 1975 · S/N 15076971 N45563Tremer Jesse · Kathleen, GABuilt 1975 · S/N 15076972 N45566Watts Charles B IV · Pace, FLBuilt 1975 · S/N 15076973 N45570San Mateo Flying Club Inc · Palo Alto, CAS/N 15076974 N45582Burch Jacqueline L · Aguanga, CABuilt 1975 · S/N 15076980 N45586Rak Aviation LLC · Everett, WABuilt 1975 · S/N 15076982 N45588Dahlonega Mountain Flyers Inc · Dahlonega, GABuilt 1975 · S/N 15076983 N455GBBrs Leasing Inc · Wilmington, DEBuilt 1982 · S/N 15285455 N45601Three Four Juliet LLC · Orange, CABuilt 1975 · S/N 15076986 N45613Devanani Vishnu D · Orlando, FLS/N 15076988 N45614Gard Lionel V III · Camp Wood, TXBuilt 1975 · S/N 15076989 N45617Schumaker Grant E · Wichita, KSBuilt 1975 · S/N 15076991 N45623Prosperous Holdings LLC · Gainesville, GABuilt 1975 · S/N 15076994 N45626Creamer James P · Lakeland, FLBuilt 1975 · S/N 15076997 N45632Marble Jere D · Dayton, NVBuilt 1975 · S/N 15076998 N45636Carolina Tripacers LLC · Summerville, SCBuilt 1975 · S/N 15076999 N45649Cygan Fred P · Hudson, MABuilt 1975 · S/N 15077006 N45659Mcallister Christopher E · Phoenix, AZBuilt 1975 · S/N 15077011 N45662Turnberry Air LLC · Oviedo, FLBuilt 1975 · S/N 15077012

Back to AD 2009-10-09 R2