Skip to content

AD 2009-10-09 R1

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-R1') 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-R1') 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-R1')
    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-R1')
  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-R1')
  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-R1')
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.

N218JAWildwood Helicopter Co Inc · Wildwood, NJBuilt 1981 · S/N 15285307 N218ZMSkylink Xpress Inc · San Bernardino, CABuilt 1977 · S/N 15280011 N21900Odonnell Edward T · Waconia, MNBuilt 1973 · S/N 15074521 N21902Sleeping Giant Flying Club Inc · Helena, MTBuilt 1973 · S/N 15074523 N21904Ragsdale Justin S · Bartlett, TNBuilt 1973 · S/N 15074525 N21908Harrison Robert W · Oak Harbor, WAS/N 15074528 N21917Kinser Jay · Monrovia, MDS/N 15074534 N21919Gustafson Dean F · Mercer, WIBuilt 1973 · S/N 15074536 N21923Averett Jeremy J · Liberty, UTS/N 15074540 N21924Berwick Mark A · Emmett, IDBuilt 1973 · S/N 15074541 N21929Holland Roy Morgan · Santa Maria, CABuilt 1973 · S/N 15074544 N21930Bonnett Paul R · Pine Valley, CABuilt 1973 · S/N 15074545 N21936Kempf Ian J · Havana, ILS/N 15074551 N21938Harrigan Kevin T · Nova, OHBuilt 1973 · S/N 15074553 N21940Smith Jan R · Helena, MTS/N 15074555 N21942Bunk Richard A · Woodbine, MDBuilt 1973 · S/N 15074557 N21951Mcnett Eric V · Topsham, MES/N 15074563 N21957Jack Daniel R · Jackson, CABuilt 1973 · S/N 15074567 N21966Barrette Richard Arthur III · Warwick, RIBuilt 1973 · S/N 15074574 N21968Hubbard Brian K · Irving, TXS/N 15074576 N21972Clauson Milo L · Corvallis, ORBuilt 1973 · S/N 15074580 N21975Gabbert Jeannette F · Prescott, AZBuilt 1973 · S/N 15074582 N21976Wojtowicz Diane L · Perry, NYBuilt 1973 · S/N 15074583 N21980Harris Kenneth L · Greeley, COBuilt 1973 · S/N 15074586 N21981Mahoney Thomas H · Dorrance, KSS/N 15074587 N21986Corr Harvey R · Nipomo, CABuilt 1973 · S/N 15074591 N21990Mcmahan William K · Sandy Valley, NVS/N 15074594 N21997Myers Donald W II · Saint Francisville, LAS/N 15074599 N219JKMiller Charles Jr · Kill Devil Hills, NCS/N 15075463 N219RADorshorst Dustin J · Deforest, WIBuilt 1971 · S/N 15072929 N21MBAarons David J · Birmingham, ALBuilt 1975 · S/N 15077002 N22001Fisher Robert G Jr · Hodges, SCBuilt 1967 · S/N 15068000 N22003Hall David D · Des Moines, WAS/N 15068002 N22009Dundon Nick · Bozeman, MTBuilt 1967 · S/N 15068006 N22014Sun Valley Aviation Inc · Harlingen, TXBuilt 1967 · S/N 15068010 N22016Kiehle Ingrid E · Anchorage, AKS/N 15068012 N22019Swindell Daniel J · Greensburg, PABuilt 1967 · S/N 15068014 N22025Scheck Christopher R · Troutdale, ORBuilt 1967 · S/N 15068016 N22027Lyles Bobbi L · Broken Arrow, OKBuilt 1967 · S/N 15068018 N22029Youth Eagles Aviation · Elk Grove, CAS/N 15068020 N2202JMartin Paul H · Willows, CABuilt 1966 · S/N 15065402 N22037Johanson Jonas P · Groveland, CAS/N 15068023 N22039Barkan James · Las Vegas, NVS/N 15068025 N22049Air Carriage Inc · Chico, CAS/N 15068030 N22053Stoddard Greg E · Anchorage, AKBuilt 1967 · S/N 15068031 N22060Watson Thomas G · Sunderland, MAS/N 15068036 N22070Mcmullen Christopher · Holt, MOBuilt 1967 · S/N 15068043 N22076Glacier Flight Training LLC · Whitefish, MTBuilt 1967 · S/N 15068047 N22078Line Electric Company LLC · Lake City, FLBuilt 1967 · S/N 15068049 N2207JCoolidge Marvin L · Newberg, ORBuilt 1966 · S/N 15065407

Back to AD 2009-10-09 R1