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.

N9494UAirgo Inc · Centralia, ILBuilt 1976 · S/N 15078442 N94959Lane Community College · Eugene, ORBuilt 1983 · S/N 15285823 N94963Twin Cities Air Service LLC · Gray, MES/N 15285825 N9499UFreer Paul Jr · Mount Airy, NCBuilt 1976 · S/N 15078447 N95005Christiansen Aviation LLC · Wilmington, DEBuilt 1984 · S/N 15285835 N95021Space Coast Aircraft Co · Merritt Island, FLBuilt 1984 · S/N 15285838 N95031Pratt John · Anchorage, AKBuilt 1984 · S/N 15285841 N95103Shelton Aviation Inc · Christiansburg, VABuilt 1984 · S/N 15285849 N95122Mcnamara Kevin M Jr · East Aurora, NYBuilt 1984 · S/N 15285852 N95159Kinne Dagmar · Woodburn, ORBuilt 1984 · S/N 15285860 N95374Board Of Trustees DBA · Murphysboro, ILBuilt 1984 · S/N 15285879 N95391Training Planes LLC · Tampa, FLBuilt 1984 · S/N 15285881 N953SASunrise Aviation Inc · Ormond Beach, FLBuilt 1980 · S/N 15283908 N95404Delta State University · Cleveland, MSBuilt 1984 · S/N 15285887 N95429Suburban Air Corp · Castro Valley, CABuilt 1984 · S/N 15285892 N95431Kent State University · Stow, OHBuilt 1984 · S/N 15285893 N95435Bird Acquisition LLC · Phoenix, AZFirst renewal noticeS/N 15285895 N95444Kent State University · Stow, OHBuilt 1984 · S/N 15285897 N95445Kent State University · Stow, OHBuilt 1984 · S/N 15285898 N95469Kent State University · Stow, OHBuilt 1984 · S/N 15285899 N95474Kent State University · Stow, OHBuilt 1984 · S/N 15285901 N95475Kent State University · Stow, OHBuilt 1984 · S/N 15285902 N954SASunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280626 N95537High Expectations LLC · Wilmington, DEBuilt 1984 · S/N 15285916 N95539Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1984 · S/N 15285917 N95551Florida Flight Training Center · Venice, FLBuilt 1984 · S/N 15285919 N95556Redstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1984 · S/N 15285922 N95606Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1984 · S/N 15285936 N95615Li LLC · Seattle, WABuilt 1984 · S/N 15285938 N95626Smith Charles · Hays, NCBuilt 1984 · S/N 15285943 N95639Barbee Donald · Columbus, OHS/N 15285949 N95646Advantage Aviation Inc · Palo Alto, CABuilt 1985 · S/N 15285951 N95670Board Of Trustees Of Southern Illinois Univ DBA · Murphysboro, ILBuilt 1985 · S/N 15285957 N956ERZulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1978 · S/N 15282201 N95722Frick Gregory A · Portland, ORBuilt 1985 · S/N 15285962 N95737Kent State University · Stow, OHBuilt 1985 · S/N 15285964 N95787Wisconsin Aviation - Four Lakes Inc · Madison, WIBuilt 1985 · S/N 15285967 N95797Kent State University · Stow, OHBuilt 1985 · S/N 15285968 N95821Kent State University · Stow, OHBuilt 1985 · S/N 15285970 N95831Space Coast Aircraft Co · Merritt Island, FLBuilt 1985 · S/N 15285972 N95840Lane Community College · Eugene, ORBuilt 1985 · S/N 15285973 N958BCBranson William E · Mooresville, NCS/N 15069902 N95936Scholey Todd A · Vacaville, CABuilt 1985 · S/N 15285987 N95993Delta State University · Cleveland, MSBuilt 1985 · S/N 15285996 N95995Hagele Aviation LLC · Hillsboro, ORBuilt 1985 · S/N 15285997 N959GTR&R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 15282116 N96092Florida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1985 · S/N 15286006 N96096Jwa Flight School LLC · Bolingbrook, ILBuilt 1985 · S/N 15286007 N963MSMount San Antonio College · Walnut, CABuilt 1982 · S/N 15285655 N963WAChase Kenneth C Jr · Rochester, MNS/N 15282882

Back to AD 2009-10-09 R2