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.

N8835SWinchester Holdings LLC · Monticello, MNS/N 15062135 N8839GRegistered aircraftBuilt 1966 · S/N 15062939 N8840SBlue Thunder Aviation LLC · Heath Springs, SCBuilt 1965 · S/N 15062140 N8841GLinn Parker J · Brainerd, MNBuilt 1966 · S/N 15062941 N8842GTiller Stanford C · Loup City, NEBuilt 1966 · S/N 15062942 N8843GSanders Don · Mustang, OKBuilt 1966 · S/N 15062943 N8847GSabillon Luis H · Concord, CABuilt 1966 · S/N 15062947 N8847URuo Hiko · Petaluma, CABuilt 1976 · S/N 15078003 N8848GFlynn John P · Colebrook, NHBuilt 1967 · S/N 15066988 N8849GSustarich Stephen M · Ketchikan, AKBuilt 1966 · S/N 15062949 N8850GSchool Board Of Seminole County Florida · Sanford, FLS/N 15062950 N8850SFlyers Park Farm LLC · Newark, OHBuilt 1965 · S/N 15062150 N8850UA & H Renovation LLC · Woodstock, GABuilt 1976 · S/N 15078004 N8851SChamseddine Ahmed A · Middletown, RIBuilt 1965 · S/N 15062151 N8851UBaird Mark · Emeryville, CABuilt 1976 · S/N 15078005 N8852GAmis Jan E · Weeki Wachee, FLS/N 15062952 N8853UDrakes Landing Inc · Archibald, LABuilt 1976 · S/N 15078006 N8855GAldrich Curtiss R · Big Oak Flat, CABuilt 1966 · S/N 15062955 N8855UBaginski D D · Salesville, OHBuilt 1976 · S/N 15078007 N8856GMorris Charles K · Miami, FLBuilt 1966 · S/N 15062956 N8858SDenney Andrew I IV · Las Cruces, NMFirst renewal noticeBuilt 1965 · S/N 15062158 N8859GBaker Jacob J · Nags Head, NCBuilt 1966 · S/N 15062959 N885WAMorcom Aviation Services Inc DBA · Everett, WAS/N 15280190 N8860GBlack Spruce Aviation LLC · Hermon, MEBuilt 1966 · S/N 15062960 N8861GMiller Andy D · Marana, AZS/N 15062961 N8861SJump Brian · Watsonville, CAS/N 15062161 N8862SBarber Theodore C Trustee · Spanish Fork, UTS/N 15062162 N8865GChiquiza Gomez Juan Camilo · Fort Pierce, FLS/N 15062965 N8866SZimmer Linda S · Hillsboro, ILBuilt 1965 · S/N 15062166 N8867GDavis Robert M · Liberal, KSBuilt 1966 · S/N 15062967 N8867SCooper-White Michael L · Orrtanna, PABuilt 1965 · S/N 15062167 N8868SMeriwether John N · Prairie Village, KSBuilt 1965 · S/N 15062168 N8871GHukill Warren J · Oakland, CABuilt 1966 · S/N 15062971 N8872GN8872g Holdings LLC · Nashville, TNBuilt 1966 · S/N 15062972 N8872SAeronautical Technical Service Inc · Collierville, TNS/N 15062172 N8873GHarris David J · Aguila, AZBuilt 1966 · S/N 15062973 N8874GEluwawalage Damayanthie · Reading, PABuilt 1966 · S/N 15062974 N8875UDunaire LLC · Mechanicsburg, PAS/N 15078009 N8878UBallard Ralph T · Hurricane, UTBuilt 1976 · S/N 15078011 N88808Thompson Patrick M · Madera, CABuilt 1974 · S/N 15076150 N8880UJackson Todd · Spirit Lake, IDBuilt 1976 · S/N 15078012 N8882GSchauer Tad J · Lake Park, MNS/N 15062982 N8882SHudson Willis · Hendersonville, NCBuilt 1965 · S/N 15062182 N8883GPalacios David J · Yucca Valley, CABuilt 1966 · S/N 15062983 N8884SMechin Jean-Michel S · Gardiner, NYBuilt 1965 · S/N 15062184 N8885GGurley George R · Caledonia, MSBuilt 1966 · S/N 15062985 N888LEStockton Raymond L · Pearl City, HIS/N 15279620 N8890SPower Gale W · Girdwood, AKBuilt 1965 · S/N 15062190 N8891GShort James B · Crown Point, INBuilt 1966 · S/N 15062991 N8891SDahlen James T · Chester, MTS/N 15062191

Back to AD 2009-10-09 R2