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.

N51285Bk Aviation Inc · Grand Prairie, TXBuilt 1968 · S/N 15069895 N51287Personal Air LLC · Wilmington, DES/N 15069897 N51288Cantley Richard W · Bluff City, TNS/N 15069898 N51292Herbert William N · Anchorage, AKBuilt 1968 · S/N 15069901 N512ADDiffenderfer Andy C · Horseheads, NYS/N 15065020 N512RSchappert Jason M · Naples, FLBuilt 1975 · S/N 15076755 N51304Stewart Roy L · Roy, UTS/N 15069909 N51306Durand Gregory M · Marquette, MIBuilt 1968 · S/N 15069911 N51314Scott John J · Arcadia, FLBuilt 1968 · S/N 15069916 N51316Devault Clayton D · Larkspur, COS/N 15069918 N51317Spitzer Terry E · Kalona, IAS/N 15069919 N51323Rathnayake Eric · Collegeville, PABuilt 1968 · S/N 15069924 N51326Lapoint Paul E · Drummond Island, MIBuilt 1968 · S/N 15069926 N51327Bowles Alan B · Georgetown, TXBuilt 1968 · S/N 15069927 N51328Butterfield Charles D · Eskridge, KSBuilt 1968 · S/N 15069928 N51333Blazey John Stanley · Palmyra, NYBuilt 1968 · S/N 15069930 N51334Cragg Noel J · Millbrae, CABuilt 1968 · S/N 15069931 N51337Garner Charlotte Trustee · Sun Lakes, AZS/N 15069933 N51343Tucker John D II · Fayetteville, GABuilt 1968 · S/N 15069939 N51345Arizona Aircraft Leasing LLC · Mesa, AZS/N 15069941 N51347Bernhardt Michael J · North Branch, MNS/N 15069942 N51355Miller Judith A · Homer, AKS/N 15069946 N51365Cavu Pilot LLC · Powell, TNBuilt 1968 · S/N 15069953 N51367Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 15069954 N51369Thorn Blake A · Coupeville, WAS/N 15069956 N51373Roberts Aviation LLC · Shreveport, LAS/N 15069959 N51374Siekmann David G · Scottsdale, AZBuilt 1968 · S/N 15069960 N51376Reaves Ronald E · Olive Branch, MSBuilt 1968 · S/N 15069962 N51385Taylor William E · Waynesville, MOBuilt 1968 · S/N 15069967 N51389Knudson Tamara M · Deer Park, WABuilt 1968 · S/N 15069970 N51393K&P Flyers LLC · Douglasville, GAS/N 15069974 N51398Twitchell Robert · Jefferson City, MOBuilt 1968 · S/N 15069979 N51400Clark Paul W · Alexandria, MNBuilt 1968 · S/N 15069981 N51401Dowling Connor · Edmonds, WABuilt 1968 · S/N 15069982 N51406Mh Aviation LLC · Le Mars, IABuilt 1968 · S/N 15069987 N5140BSesnic Aidan · Mukilteo, WABuilt 1979 · S/N 15283772 N51410Good Paul H · Long Island, VABuilt 1968 · S/N 15069990 N51411Lambourne Robert · Pensacola, FLBuilt 1968 · S/N 15069991 N51412Record John W · Apison, TNS/N 15069992 N51415Van Voorhis Adam P · Groton, CTBuilt 1968 · S/N 15069995 N51416Murphy Nicholas Raymond · Kenai, AKBuilt 1968 · S/N 15069996 N5144BCloud Dancer Aviation Inc · Deland, FLBuilt 1979 · S/N 15283774 N5144LEmpire Aviation · Oxford, NCBuilt 1980 · S/N 15284270 N5151BTakai Hiroyasu · San Jose, CABuilt 1979 · S/N 15283778 N5151LTownsend Richard · Barrington, NHBuilt 1980 · S/N 15284273 N5155PKline John C · Wolcottville, INBuilt 1981 · S/N 15284885 N515RVFlying Adventures Tm LLC · Talkeetna, AKBuilt 1975 · S/N A1500594 N5165BNovember 46a Leasing Inc · St Augustine, FLBuilt 1979 · S/N 15283783 N5174BSky Associates Inc · Jupiter, FLBuilt 1979 · S/N 15283790 N5183PAig Aeronautics LLC · Guaynabo, PRBuilt 1981 · S/N 15284890

Back to AD 2009-10-09 R2