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.

N51106Iron Horse Leasing LLC · Platteville, WIBuilt 1968 · S/N 15069770 N51108Jstream Lc · Sheridan, WYBuilt 1968 · S/N 15069772 N51113Wander Robert P · Faribault, MNBuilt 1968 · S/N 15069775 N51115Bernhardt Michael J · North Branch, MNS/N 15069777 N51116Koehn Mark W · Elkader, IAS/N 15069778 N51124Kd Farms Inc · Cosmos, MNBuilt 1968 · S/N 15069781 N51126Ostrander William P · Millerton, PABuilt 1968 · S/N 15069782 N51133Riegle Shannon D · Muncie, INBuilt 1968 · S/N 15069784 N51134Jstream Lc · Sheridan, WYBuilt 1968 · S/N 15069785 N51135Liberty Belle Aviation LLC · Vista, CABuilt 1968 · S/N 15069786 N51136St Denis Matthew · Mountlake Terrace, WAFirst renewal noticeBuilt 1968 · S/N 15069787 N51147Penn Mitchell · Poplar Bluff, MOBuilt 1968 · S/N 15069795 N51156Knutson Wayne R · Tioga, NDS/N 15069801 N51162Raia James · Vero Beach, FLS/N 15069805 N51165Detroit Public Schools Community District · Detroit, MIBuilt 1968 · S/N 15069808 N51167Cusick Christopher J · La Jolla, CABuilt 1968 · S/N 15069809 N51168Cherry Hill Aviation C182 LLC · Freetown, INBuilt 1968 · S/N 15069810 N5116QAvolant Aviation LLC · Mooresville, NCBuilt 1981 · S/N 15285078 N51170Northern Sonic Alaska Inc · Fairbanks, AKBuilt 1968 · S/N 15069812 N51171Spruill William F · Wyoming, DEBuilt 1968 · S/N 15069813 N51174Tomah Flying Club Inc · Kendall, WIBuilt 1968 · S/N 15069815 N51177Mohiuddin Waqar S · The Woodlands, TXBuilt 1968 · S/N 15069818 N5117G5117g LLC · Sandy, ORS/N 15065640 N51186Jones Stephen C · Wadsworth, ILBuilt 1968 · S/N 15069825 N51188Yuma Aero Services LLC · Yuma, AZBuilt 1968 · S/N 15069827 N51189Caufman Roger B · Loganville, GABuilt 1968 · S/N 15069828 N51195Martel Ian G · Proctorsville, VTBuilt 1968 · S/N 15069831 N51196Lienau Joseph E · Fish Creek, WIBuilt 1968 · S/N 15069832 N511GMCrothall George · Oceanside, CABuilt 1968 · S/N 15069802 N51206King Aviation LLC · Altamont, MOBuilt 1968 · S/N 15069838 N51209Green Harvey D · Germantown, TNBuilt 1968 · S/N 15069840 N5120HTraining Planes LLC · Tampa, FLBuilt 1979 · S/N 15284063 N51219Szostak Edward M · San Diego, CABuilt 1968 · S/N 15069845 N5121LSouthwinds Export Inc · Kissimmee, FLNon-citizen corporation, flight hours not reportedS/N 15284268 N51220Trevillyan Bart L · Hot Springs, SDS/N 15069853 N51223James Joseph E · Janesville, WIBuilt 1968 · S/N 15069848 N51224Rettenmeyer Ryan J · Buford, GABuilt 1968 · S/N 15069849 N51225Riccelli Zack Louis · Portland, ORBuilt 1968 · S/N 15069850 N5122BTutt Bryan D · Louisville, KYBuilt 1979 · S/N 15283759 N5122PBluesky Equipment LLC · Panama City, FLBuilt 1981 · S/N 15284882 N51232Hawk Hangars Corporation LLC · Jenks, OKS/N 15069857 N5124BHillsboro Aero Academy Llcc · Hillsboro, ORBuilt 1979 · S/N 15283761 N51251Technical Education Services Inc DBA · Virginia Beach, VABuilt 1968 · S/N 15069872 N51256Miller Andy · Marana, AZBuilt 1968 · S/N 15069875 N51257Burnham Nathaniel · Eagle Mountain, UTBuilt 1968 · S/N 15069876 N51258Nelson Otis · Portage, MEBuilt 1968 · S/N 15069877 N5125BSnohomish Flying Service Inc · Snohomish, WABuilt 1979 · S/N 15283762 N51266Reiter Marc · Hooks, TXBuilt 1968 · S/N 15069881 N51275Hollow David C · Knoxville, TNBuilt 1968 · S/N 15069887 N51284Stallbaumer Roger P · Seneca, KSBuilt 1968 · S/N 15069894

Back to AD 2009-10-09 R2