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.

N23302Adams John C · Gladstone, MOBuilt 1968 · S/N 15068860 N23303Chuzy Suzy LLC · Lafayette, LABuilt 1968 · S/N 15068861 N23304Gendy Shady S · Columbia, PABuilt 1968 · S/N 15068862 N23305Fuhrmann Brandon R · Aberdeen, SDBuilt 1968 · S/N 15068863 N23308Hotel Bravo Aviation LLC · Sumrall, MSBuilt 1968 · S/N 15068864 N23311Sweeney Daniel W · Broad Brook, CTBuilt 1968 · S/N 15068866 N23322Lopez William Alberto · Miami, FLBuilt 1968 · S/N 15068873 N23323Boccaccio Peter Anthony · Burke, SDBuilt 1968 · S/N 15068874 N23324Walden James F · Willcox, AZBuilt 1968 · S/N 15068875 N23328Scmitt Rudy · Brookshire, TXBuilt 1968 · S/N 15068876 N23329Welles Richard V · Elmira, NYBuilt 1968 · S/N 15068877 N23330N23330 LLC · Bedford, PABuilt 1968 · S/N 15068878 N23333Leading Edge Aviation LLC · Lewiston, IDBuilt 1968 · S/N 15068880 N23337Mosquito LLC · Chesaning, MIBuilt 1968 · S/N 15068883 N23344Hmh Consolidated LLC · Lake Placid, FLBuilt 1968 · S/N 15068888 N23348Noel Tom W · Galloway, OHBuilt 1968 · S/N 15068890 N23349Fairwinds Aviation LLC · Goldsboro, NCBuilt 1968 · S/N 15068891 N23350Kimbrel Martin E · Oakville, WABuilt 1968 · S/N 15068892 N23357603 Flight LLC · Nashua, NHS/N 15068898 N23359Moore Everett A · New Lexington, OHBuilt 1968 · S/N 15068900 N23360Xc Aviation LLC · Wyckoff, NJBuilt 1968 · S/N 15068901 N23364Ephraim Flyers Inc · Ephraim, WIBuilt 1968 · S/N 15068904 N23365Del Rossa Erwin R · Sodus, NYBuilt 1968 · S/N 15068905 N23370Carruthers John H Jr · Berlin, NHBuilt 1968 · S/N 15068909 N23372Dold Stephen E · Foresthill, CABuilt 1968 · S/N 15068911 N23374Pannell Lucas J · Midland City, ALBuilt 1968 · S/N 15068913 N23382Galster Scott · Oneonta, NYBuilt 1968 · S/N 15068918 N23386Perta Steven J · Rome, NYBuilt 1968 · S/N 15068920 N23387Strickland Kim A · Bowling Green, OHBuilt 1968 · S/N 15068921 N23390Smp LLC · Kenner, LAS/N 15068924 N23391Porter Scott · Aguila, AZBuilt 1968 · S/N 15068925 N23392Mullins Adrian · Cartersville, GABuilt 1968 · S/N 15068926 N23398Murillo Anthony · Davis, CABuilt 1968 · S/N 15068928 N233SHSieger Aviation Services Inc · Bismarck, NDBuilt 1979 · S/N 15283714 N23421High Exposure Inc · Wilmington, DEBuilt 1968 · S/N 15068938 N23422Air Logistics Group LLC · Winston Salem, NCS/N 15068939 N23435Depinet Thomas E · Mount Gilead, OHS/N 15068944 N23437603 Flight LLC · Nashua, NHBuilt 1968 · S/N 15068945 N23440American Sky Aviation LLC · Anna, TXBuilt 1968 · S/N 15068947 N23443Henson Joseph A · Jasper, ALBuilt 1968 · S/N 15068949 N23444Garrett Scott E DBA · Owensville, INBuilt 1968 · S/N 15068950 N23453Harrier Aviation LLC · South Saint Paul, MNBuilt 1968 · S/N 15068957 N23458Blue Skies Aircraft LLC · Kalispell, MTBuilt 1968 · S/N 15068961 N23460Clark Johnathan W · Coventry, CTBuilt 1968 · S/N 15068963 N23461Egipciaco Jeffrey · Hampstead, NCBuilt 1968 · S/N 15068964 N23469N23469 LLC · Rehoboth Beach, DEBuilt 1968 · S/N 15068970 N23473G Force Advantage LLC · Lewes, DEBuilt 1968 · S/N 15068973 N23476Horizon Flight Center LLC · Chesapeake, VABuilt 1968 · S/N 15068976 N23486Hite Michael B · Martinsburg, WVBuilt 1968 · S/N 15068983 N23489Knebel Chris DBA · Boston, VABuilt 1968 · S/N 15068985

Back to AD 2009-10-09 R2