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.

N9114UMarek John M · Tucson, AZBuilt 1976 · S/N 15078065 N9115UWigley Ben F Jr · Huntington, ORFirst renewal noticeS/N 15078066 N9117UBahr Timmy A · Crandon, WIBuilt 1976 · S/N 15078068 N9118U9118u LLC · Dover, IDBuilt 1976 · S/N 15078069 N9124USmith Stanley P · Athens, ALBuilt 1976 · S/N 15078075 N9128UHarrell Brian · Donalsonville, GABuilt 1976 · S/N 15078079 N9130UTravis Gary E · Raleigh, NCBuilt 1976 · S/N 15078081 N9131UVarivoda Marina Y · Miami, FLS/N 15078082 N9132UBishop Michael J · Poulsbo, WABuilt 1976 · S/N 15078083 N913TAChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 15285317 N9140ULegore William G · Windsor, WIBuilt 1976 · S/N 15078091 N9143USherer Preston A · Watertown, WIBuilt 1976 · S/N 15078094 N9145USharp Wayne H · Mena, ARBuilt 1976 · S/N 15078096 N914EYDreimiller Raymond J Jr · Bloomfield, NYBuilt 1976 · S/N 15079131 N9151UAdvanced Aviation LLC · New Century, KSBuilt 1976 · S/N 15078102 N9156UHangar6 Aviation LLC · Apex, NCBuilt 1976 · S/N 15078107 N9157URoss Stephen D · Greenfield, OHS/N 15078108 N9159UHac Plane LLC · Sugar Land, TXBuilt 1976 · S/N 15078110 N915AAHoecher Robert T · Anchorage, AKFirst renewal noticeBuilt 1977 · S/N 15280359 N9162UDag Arda Orcun · Mount Dora, FLBuilt 1976 · S/N 15078113 N9164UUnderwood Callum M · Canton, GABuilt 1976 · S/N 15078115 N9165ULudwiczak Damian · Medina, OHBuilt 1976 · S/N 15078116 N9166UKsnl Aero LLC · Shawnee, OKBuilt 1976 · S/N 15078117 N9167CNew Garden Township · Landenberg, PABuilt 1972 · S/N 15074232 N9167UTobin Dustin J · Hesperia, CABuilt 1976 · S/N 15078118 N9168UC150 LLC · Gilbert, AZBuilt 1976 · S/N 15078119 N9169UVipperman Richard Madison Jr · Martinsville, VABuilt 1976 · S/N 15078120 N9174UYoung Steven J · Taneyville, MOBuilt 1976 · S/N 15078125 N9178UPerguson Robert C · Converse, TXBuilt 1976 · S/N 15078129 N9179UHartman Karin R · Kokomo, INBuilt 1976 · S/N 15078130 N9183UJody M Bryson DBA · Richards, MOBuilt 1976 · S/N 15078134 N91848Mike Alpha Mike LLC · Lafayette, LABuilt 1967 · S/N 15067491 N9185UChristopher P Riley · Everett, WABuilt 1976 · S/N 15078136 N9186USmith John Dial Jr · Lexington, SCBuilt 1976 · S/N 15078137 N918UGriffith Aviation Inc · Griffith, INBuilt 1981 · S/N 15285441 N9191UN9191u LLC · California, MDBuilt 1976 · S/N 15078142 N9193UVan Buskirk Bill J · Wasilla, AKBuilt 1976 · S/N 15078144 N9197UWarfel Everett E · Greenwood, DEBuilt 1976 · S/N 15078148 N91HLWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1982 · S/N 15285648 N91RBlack Pilots Of America Detroit Chapter · Detroit, MIS/N 15067793 N9200UCherry Hill Aviation Inc · Freetown, INBuilt 1976 · S/N 15078151 N9203UAlaskan Mariners Inc · Homer, AKBuilt 1976 · S/N 15078154 N9208UEllefson Nicholas · Duluth, MNBuilt 1976 · S/N 15078159 N920BEGalaxy Aviation LLC · Nantucket, MABuilt 1979 · S/N 15283538 N9210UKing Bill R · Cadillac, MIBuilt 1976 · S/N 15078161 N9211UMaster Gregory A · Mesa, AZBuilt 1976 · S/N 15078162 N92140Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1981 · S/N 15285371 N9217UWallace John L · Bethel, AKS/N 15078167 N9218UHolzgrove Thomas H · Pipestone, MNS/N 15078168 N9219UCarlson Farms Inc · Plentywood, MTBuilt 1976 · S/N 15078169

Back to AD 2009-10-09 R2