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.

N1723QScroggy Edward R · Louisville, KYBuilt 1971 · S/N 15073023 N17251Aurora 17 Holdings LLC · Aurora, ORBuilt 1972 · S/N 15073687 N17256Smith Taylor C · Amarillo, TXBuilt 1972 · S/N 15073692 N17257Johnson Ralph R · Roanoke Rapids, NCBuilt 1972 · S/N 15073693 N17258Registered aircraftS/N 15073694 N17260Woodley Aerial Leasing LLC · Walnut, ILS/N 15073696 N17263Medbery Nathan J · Minto, NDS/N 15073698 N17266Stroup Trey C · Fort Pierre, SDS/N 15073701 N17267Munch James L · Aumsville, ORBuilt 1972 · S/N 15073702 N1727QGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 1971 · S/N 15073027 N1728QUnd Aerospace Foundation · Grand Forks, NDBuilt 1970 · S/N 15071920 N17291Region Flyers LLC · Valparaiso, INBuilt 1972 · S/N 15073704 N17293Kieren Bryce J · Tucson, AZBuilt 1972 · S/N 15073706 N17295Alaverdi Omeed · California, MDBuilt 1972 · S/N 15073708 N17298Biller Luke A · Milton, DEBuilt 1972 · S/N 15073711 N17299Sale Reported · Mobile, ALSale reportedBuilt 1972 · S/N 15073712 N1735QMadden David · Bethlehem, NHBuilt 1971 · S/N 15073035 N17371Lynch Kyle R · Palmetto, FLBuilt 1972 · S/N 15073714 N17375Jts Aircraft LLC · Rock Hill, SCBuilt 1972 · S/N 15073718 N1737QWilliams Kamille N · Juneau, AKS/N 15073037 N17382Hagelstein Ele C · Sanderson, TXRegistration expired, pending cancellationBuilt 1972 · S/N 15073715 N1747QAleyda Aviation LLC · Berlin, NJBuilt 1972 · S/N 15073047 N1749QScott Andrew F · Beaufort, SCBuilt 1971 · S/N 15073049 N1756QVerhalen John P Jr · Scottsville, TXBuilt 1971 · S/N 15073056 N1768QHarper John T · Fairfield, OHBuilt 1971 · S/N 15073068 N1769QPmn Enterprises LLC · Fremont, WIBuilt 1971 · S/N 15073069 N1775QBrooks Timothy J · Oshkosh, WIS/N 15073075 N177BDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281660 N1780QDabone Salim · Dell City, TXBuilt 1971 · S/N 15073080 N1784QRed Cardinal Aviation LLC · Chantilly, VAS/N 15073084 N1787QHancock Aviation LLC · Baton Rouge, LABuilt 1971 · S/N 15073087 N1788QElgamil Noureldin M · West New York, NJBuilt 1971 · S/N 15073088 N1791QNearpass Stephen J · Seneca Falls, NYS/N 15073091 N1793QFreedom Aviation Inc · Lynchburg, VABuilt 1971 · S/N 15073093 N179DBBrisco Daniel J · Fort Myers, FLS/N 15075498 N17FGWard Bruce L · Key West, FLBuilt 1976 · S/N 15077906 N17RRRiverside Flight Center Inc · Tulsa, OKBuilt 1979 · S/N 15284134 N18004Hause James H · Negley, OHBuilt 1972 · S/N 15073722 N18006Lockhart Curtis M · Bay Village, OHBuilt 1972 · S/N 15073724 N18015Little Bird 150 LLC · Lake Tapps, WABuilt 1972 · S/N 15073732 N18020N18020 LLC · Chandler, AZBuilt 1972 · S/N 15073736 N18021Tilden Jeffrey D · Columbus, INS/N 15073737 N18023Remain In The Pattern LLC · Meridian, IDBuilt 1972 · S/N 15073739 N18025Evans II Rodney D · Saint Albans, WVBuilt 1972 · S/N 15073741 N18032Old School Aircraft LLC · Jackson, TNBuilt 1972 · S/N 15073747 N18033Barkley John · Austin, TXBuilt 1972 · S/N 15073748 N18042Carey Daniel F · Rockville Centre, NYS/N 15073754 N18046Beavers David A · Strasburg, COS/N 15073757 N18050Jarrell Loyd F · Whitesburg, TNBuilt 1972 · S/N 15073759 N18052Sky Views LLC · Mount Crawford, VABuilt 1972 · S/N 15073760

Back to AD 2009-10-09 R2