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.

N4784AFox Aviation International Inc · Justin, TXBuilt 1979 · S/N A1520891 N4784XOgletree Ben R Jr · Livingston, TXBuilt 1966 · S/N 15064834 N47856Vector-USA LLC · Olive Branch, MSBuilt 1979 · S/N 15283258 N4785BBravo Zulu Aviation LLC · Torrance, CAS/N 15283633 N4786PAce High Aviation LLC · Long Beach, CAS/N 15284816 N4789XGrald Jonathan A · Goshen, NYFirst renewal noticeBuilt 1966 · S/N 15064839 N478BKWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15281022 N4791QSelzer Robert S · Anchorage, AKBuilt 1981 · S/N 15285063 N4791XBowden Wyatt D · Hamburg, ARBuilt 1966 · S/N 15064841 N47930Nextgen Flight Academy Inc · Riverside, CAS/N 15283263 N4795XHopkins Eric J · Wasilla, AKBuilt 1966 · S/N 15064845 N4797XChadwell Letch J · Hulbert, OKBuilt 1966 · S/N 15064847 N4799ANew England Aircraft Detailing LLC · Webster, MABuilt 1979 · S/N A1520893 N4799XBee Air LLC · Evansville, INBuilt 1966 · S/N 15064849 N47PFour Seasons Aviation Inc · Albuquerque, NMBuilt 1977 · S/N 15079224 N4800MDunn Bernard P · Carson City, NVBuilt 1980 · S/N 15284484 N4800XHoistad Rick Allen · Forman, NDS/N 15064850 N48024Aftcloud Inc · Ontario, CABuilt 1979 · S/N 15283270 N48033Franconi Michael J · Newington, CTBuilt 1979 · S/N 15283271 N48042Simmons Kenton L · Van Alstyne, TXBuilt 1979 · S/N 15283273 N48056Little Duke Aviation LLC · Saint Paul, MNBuilt 1979 · S/N 15283276 N48068Ikarus Aviation LLC · Salt Lake City, UTBuilt 1979 · S/N 15283277 N4806BMckinney Brett A · Hackleburg, ALBuilt 1979 · S/N 15283647 N4807BSun Aircraft Management LLC · Ormond Beach, FLBuilt 1979 · S/N 15283648 N4807XHile Daniel A · Clearfield, PABuilt 1966 · S/N 15064857 N4809XKc Aviation LLC · Kalispell, MTBuilt 1966 · S/N 15064859 N4811FHurlston Glenn D · Leesville, LABuilt 1973 · S/N A1500417 N48156Perdue Ralph R Jr · Blacklick, OHBuilt 1979 · S/N 15283291 N48167American Aviation Inc · Brooksville, FLBuilt 1979 · S/N 15283293 N4817BPriority One Insurance & Investments Inc · Hillsboro, NDBuilt 1979 · S/N 15283653 N4818XSchmitt Justin M · Shawneetown, ILBuilt 1966 · S/N 15064868 N4819BSunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15283654 N481CGGill Christopher W · Aiken, SCBuilt 1971 · S/N 15073054 N48204Young Achilles Hsi-Jung · La Habra, CABuilt 1979 · S/N 15283301 N48222N1705r Inc · Cobb, CAS/N 15283303 N48228M & L Utility Contractors Inc · Cottondale, FLBuilt 1979 · S/N 15283304 N48238Hamilton Brandon T · Morehead, KYBuilt 1979 · S/N 15283306 N48239Harrell Robert L · Brooksville, FLBuilt 1979 · S/N 15283307 N4823LLaguna Verde Leasing Inc · Wilmington, DES/N 15284233 N4823XVon Bernewitz David A · Myersville, MDBuilt 1966 · S/N 15064873 N48241Evans Christopher Warren · Demotte, INBuilt 1979 · S/N 15283308 N48244Kelly Kevin J · Lancaster, NYBuilt 1979 · S/N 15283310 N4824PMikhailau Ivan · Alpine, UTBuilt 1980 · S/N 15284823 N4824XPowell Kevin D · Nampa, IDS/N 15064874 N48270Stephenson Christopher J · Rindge, NHBuilt 1979 · S/N 15283315 N4827XPpy Fly Corp · Atlanta, GAS/N 15064877 N48286Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283320 N4828BGc Aviation Services-1 LLC · Miamisburg, OHBuilt 1979 · S/N 15283660 N4828XGillette David L · Carrollton, TXFirst renewal noticeBuilt 1966 · S/N 15064878 N4829PBoard Of Trustees Of University Of Illinois · Savoy, ILBuilt 1980 · S/N 15284824

Back to AD 2009-10-09 R2