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.

N5186LKlippel Charlie L · Huntington Beach, CABuilt 1980 · S/N 15284276 N5189BFreedom Aviation Of America LLC · Newcastle, TXBuilt 1979 · S/N 15283797 N519Malaska Jacob L · Orefield, PABuilt 1966 · S/N 15064303 N5202QRosso Matthew J · Mancos, COS/N 15073102 N5203QMatteis Vincent M · Lyndonville, VTBuilt 1971 · S/N 15073103 N5204QWarren County Career Center · Lebanon, OHBuilt 1971 · S/N 15073104 N5206MAeropaws Aviation LLC · Front Royal, VABuilt 1980 · S/N 15284504 N5208QEmerick Benjamin F · Foster, RIBuilt 1971 · S/N 15073108 N5209QTulsa Technology Center School District No 18 · Tulsa, OKS/N 15073109 N520JCSisson Christopher S · Sarah, MSS/N 15073129 N5213QMedia Stew LLC · Carson City, NVBuilt 1971 · S/N 15073113 N5214QMann Roland F · Murrayville, GABuilt 1971 · S/N 15073114 N5217QGoode Stephen C · Canton, TXS/N 15073117 N5219QVital Aviation LLC · Monterey, CABuilt 1971 · S/N 15073119 N5220MCummings Brian · Opelousas, LABuilt 1980 · S/N 15284506 N5223LN5223l LLC · Cheyenne, WYBuilt 1980 · S/N 15284279 N5223QThealphamart LLC · Saint Petersburg, FLBuilt 1971 · S/N 15073123 N5224QRiibe Gary J · Herman, NEBuilt 1971 · S/N 15073124 N5225QMiller Kevin L · Arlington, WABuilt 1971 · S/N 15073125 N5227QFoster Kathleen E · Long Beach, CABuilt 1971 · S/N 15073127 N5229BPisha Vincent R · Kendall, WIBuilt 1979 · S/N 15283812 N522DRIbrahim Tarek M · Lawrenceville, VABuilt 1966 · S/N 15063327 N522KSkyhigh Aviation Investments Inc · Daytona Beach, FLBuilt 1974 · S/N 15075544 N5233PAero Quest LLC · Olive Branch, MSBuilt 1981 · S/N 15284898 N5235QPoules Alexander · Hope Valley, RIBuilt 1972 · S/N 15073135 N5236HCarter Flygare Inc · Sacramento, CABuilt 1979 · S/N 15284070 N5236QPeters Terry M · Okeechobee, FLBuilt 1972 · S/N 15073136 N5237QKretschmer Bryan · Hawthorne, NJBuilt 1972 · S/N 15073137 N5238QMolek Jon · Warren, OHBuilt 1972 · S/N 15073138 N5239BGanim Rose B · Haydenville, MABuilt 1980 · S/N 15284366 N5239QWayland Johnny R · Stephenville, TXS/N 15073139 N5240QRamesh Manohari D · Liberty Township, OHBuilt 1972 · S/N 15073140 N5241PAtwater John G · Vero Beach, FLS/N 15284899 N5241QWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 15285088 N5242QShimata Kenneth S · Honolulu, HIBuilt 1972 · S/N 15073142 N5243QCas Ltd · Swanton, VTRegistration expired, pending cancellationBuilt 1981 · S/N 15285089 N5246QEast Hill Flying Club Inc · Ithaca, NYBuilt 1981 · S/N 15285092 N5247QCavu Pilot LLC · Powell, TNS/N 15073147 N5248QSmith Gary A · Ericson, NEBuilt 1972 · S/N 15073148 N5249QLarson Loren R · Omro, WIBuilt 1972 · S/N 15073149 N524HFBa Group LLC · Glastonbury, CTS/N 15283436 N5250QLegan Matthew · Franklin, INBuilt 1972 · S/N 15073150 N5255FHirsch Jeffrey D · Lutherville, MDS/N 15073155 N5258BMathis Ryan B · Madison, ALS/N 15283818 N5259QFrantz David L · Murfreesboro, TNBuilt 1972 · S/N 15073159 N525HFVintage Wings Aircraft LLC · Center Point, INBuilt 1977 · S/N 15280442 N525SHMcn Systems LLC · Mount Airy, MDBuilt 1965 · S/N 15062549 N5260PKaufman Charles · West Palm Beach, FLBuilt 1981 · S/N 15284902 N5265LHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284283 N5265QCohan John K · Marina, CABuilt 1972 · S/N 15073165

Back to AD 2009-10-09 R2