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.

N482ALKcantarano LLC · Mulkilteo, WAS/N A1500223 N48306Bargo Marvin Rae Jr · London, KYBuilt 1979 · S/N 15283323 N4830BRussell Dwight R · Milo, MEBuilt 1979 · S/N 15283661 N4831XSeebold Dustin K · Mifflinburg, PABuilt 1966 · S/N 15064881 N4832XBaranski Charles J · New Windsor, NYBuilt 1966 · S/N 15064882 N48333Central Texas College · Killeen, TXBuilt 1979 · S/N 15283324 N48340Candace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 15283326 N4834XTalluri Naga Hareesh · Round Rock, TXBuilt 1966 · S/N 15064884 N4838BAerolina Inc · Hendersonville, NCBuilt 1979 · S/N 15283665 N4838XHannah Danny Lee · Elnora, INBuilt 1966 · S/N 15064888 N48400Vector-USA LLC · Olive Branch, MSBuilt 1979 · S/N 15283332 N4840XDel Valle Arnoldo · Sandia, TXBuilt 1966 · S/N 15064890 N48410Azar Suzanne S · El Paso, TXS/N 15280907 N4842XKlemann Rose Marie · West Glacier, MTBuilt 1966 · S/N 15064892 N4843BMaddox Emily Brown · Rosharon, TXBuilt 1979 · S/N 15283668 N48440Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280910 N4847BCrossbrook LLC · Willoughby, OHBuilt 1979 · S/N 15283670 N48481Oklahoma State University · Stillwater, OKBuilt 1979 · S/N 15283342 N4849XSeyfer Bradley W · Renton, WABuilt 1966 · S/N 15064899 N48500R&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 15280914 N4850HGreen Airport Development Corp · Kemah, TXBuilt 1979 · S/N 15283985 N4851BCode Supplies Inc · Lakeland, TNBuilt 1979 · S/N 15283673 N48521Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283346 N4852PGreenwood Auto LLC · Itta Bena, MSBuilt 1980 · S/N 15284831 N48549Davies Richard E · Sequim, WABuilt 1979 · S/N 15283349 N48568Spartan Education LLC · Tulsa, OKBuilt 1979 · S/N 15283350 N48581Luis Enrique Quintana · Miami, FLS/N 15283351 N48590Heavy Metal Air LLC · Farmingdale, NYS/N 15280920 N4860BWeaver Dianna K · Benton, LABuilt 1979 · S/N 15283678 N48610Redstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1977 · S/N 15280922 N48637K S Aviation · Atwater, CABuilt 1977 · S/N 15280924 N48650Herion Chris W · Williamsburg, VABuilt 1977 · S/N 15280926 N48690Chamberlin William C · Williamsburg, MIBuilt 1977 · S/N 15280929 N4869LCentral Texas College · Killeen, TXBuilt 1980 · S/N 15284237 N48708Greene Caleb M · Laverne, CAS/N 15280934 N4870PWooten Gerry W · Edmond, OKBuilt 1980 · S/N 15284834 N48710Conner Michael James · Scotts Valley, CABuilt 1977 · S/N 15280935 N48725Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280937 N4874BKoppelmann Kevin J · Cuba, MOS/N 15283687 N48751Tyau Jon S · Las Vegas, NVBuilt 1977 · S/N 15280951 N48753Harford Flying Club Inc · Kingsville, MDBuilt 1977 · S/N 15280952 N48757Stone To Glass LLC · Lake Worth, FLBuilt 1977 · S/N 15280956 N48762Carter Flygare Inc · Sacramento, CABuilt 1979 · S/N 15283369 N48763Jet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15280959 N48764Cohen Harold L · Pensacola, FLBuilt 1979 · S/N 15283370 N48768General Aviation Support Corp · Rosamond, CAS/N 15283371 N48779Bryan Robert G · Orland Park, ILBuilt 1977 · S/N 15280963 N48787Angel Aviation Inc · Peoria, AZBuilt 1977 · S/N 15280967 N4878BSun Aircraft Management LLC · Ormond Beach, FLBuilt 1979 · S/N 15283689 N487XACrafa Steven J · Golden, COBuilt 1973 · S/N 15075242

Back to AD 2009-10-09 R2