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.

N532RSZacherl Randall L · Indiana, PABuilt 1980 · S/N 15284322 N5330QBend Aircraft Mechanics LLC · Bend, ORBuilt 1972 · S/N 15073230 N5335PFlying Vikings Inc · Hayward, CABuilt 1981 · S/N 15284919 N5337LFather Son Ing LLC · Wilmington, DEBuilt 1980 · S/N 15284296 N5337PHanson David J · Elgin, TXBuilt 1981 · S/N 15284920 N53380Haltom Gary D · Alva, OKS/N 15283540 N5338QFly By Knight LLC · Louisville, KYBuilt 1972 · S/N 15073238 N5339BFiebig Howard J · Sebewaing, MIBuilt 1979 · S/N 15283841 N5342PSp Airparts LLC · Moscow, IDBuilt 1981 · S/N 15284921 N5344BJohn Annin LLC · Fenton, MOBuilt 1979 · S/N 15283843 N5344MPinger Kevin R · Palo Alto, CABuilt 1980 · S/N 15284548 N5344QGraber Quinten R · Brooksville, MSS/N 15073244 N5345MNew Orleans Aerial Tours & Flight Training LLC · New Orleans, LABuilt 1980 · S/N 15284549 N5345QRegistered aircraftBuilt 1972 · S/N 15073245 N5346QCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1972 · S/N 15073246 N5348BBowers Curt E · Jennings, LABuilt 1979 · S/N 15283844 N5350MNewsom Bearden And Cobb Inc DBA · Lubbock, TXBuilt 1980 · S/N 15284553 N5350PChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 15284924 N5351LHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284298 N5351PPointair Aviation Inc · Port Jeff Sta, NYS/N 15284925 N5353HDe Nunzio Arnold J · Ballard, CABuilt 1979 · S/N 15284090 N5353QRegistered aircraftBuilt 1972 · S/N 15073253 N5355PPittsburgh Pilot Training LLC · Bethel Park, PABuilt 1981 · S/N 15284926 N5355QGorge Winds Aviation Inc · Fairview, ORBuilt 1981 · S/N 15285104 N5357HRichmor Aviation Inc · Hudson, NYBuilt 1979 · S/N 15284092 N5357PSunrise Aviation Inc · Ormond Beach, FLBuilt 1981 · S/N 15284927 N5359Q620 Stanley Aviation LLC · Meridian, IDBuilt 1972 · S/N 15073259 N535DBMansfield David E · Ashland, KYS/N 15078237 N5361QBushre David N · Janesville, WIBuilt 1972 · S/N 15073261 N5362QHelderman Curtis L · Newton, NCBuilt 1972 · S/N 15073262 N5364POwens Flight Training LLC · Lafayette, LABuilt 1981 · S/N 15284929 N5366MHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284566 N5367QLeatherneck Aviation LLC · Billings, MTBuilt 1972 · S/N 15073267 N5368MPacific Union College · Angwin, CABuilt 1980 · S/N 15284567 N5368QMobley Christopher M · Keysville, GAS/N 15073268 N5369HValdiosera Octavio · Tracy, CABuilt 1980 · S/N 15284094 N5369QAirfleet Solutions LLC · Newark, DES/N 15073269 N5373QMallatt Michael N · Galena, KSBuilt 1972 · S/N 15073273 N5378BDraper Floyd L · El Paso, TXBuilt 1979 · S/N 15283855 N5379QSky Limit Services LLC · Miami, FLBuilt 1972 · S/N 15073279 N5380QFoy Timothy D · Malvern, PABuilt 1972 · S/N 15073280 N5381QAirgo Inc · Centralia, ILBuilt 1972 · S/N 15073281 N5382QMiller Charles L · Mooresville, NCBuilt 1972 · S/N 15073282 N5383MSunrise Aviation Inc · Ormond Beach, FLBuilt 1980 · S/N 15284572 N5383QEight Three Quebec LLC · Arlington, VABuilt 1972 · S/N 15073283 N5384PKs Aviation Inc · Atwater, CABuilt 1981 · S/N 15284934 N5387BHuffman Jacob M III · Burleson, TXBuilt 1979 · S/N 15283857 N5389MChapel Hill Flying Club DBA · Sanford, NCBuilt 1980 · S/N 15284576 N5389QCieri Joe · Graves Mill, VABuilt 1981 · S/N 15285107 N5390QIgnarro Jessie · Bay Shore, NYS/N 15073290

Back to AD 2009-10-09 R2