OpenAirDocs.org
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
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.

N19481Majors Flying Club · Greenville, TXBuilt 1973 · S/N 15074443N19486Beavers David Allen · Strasburg, COS/N 15074444N194961w1 Aero LLC · Issaquah, WABuilt 1973 · S/N 15074450N19506Colvard Tony D · Newland, NCS/N 15074457N19508Andelt David L · Parker, COBuilt 1973 · S/N 15074459N19514N&C Enterprises LLC · Vine Grove, KYS/N 15074461N19516Choppin Dale · Sun City, AZBuilt 1973 · S/N 15074462N19520Ag Avventures LLC · Hartford, WIS/N 15074465N19522Cannan Aviation Inc · Georgetown, TXS/N 15074467N19523Frana Joel A DBA · Fort Myers, FLBuilt 1973 · S/N 15074468N19524Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1973 · S/N 15074469N19526Soebagyo Vincent · Hollywood, CABuilt 1973 · S/N 15074471N19531Archer Collins Etheridge · Fairview, TXBuilt 1973 · S/N 15074476N19534Smith Paul C Sr · Winthrop, MES/N 15074479N19550Cheap Flight Time LLC · Athens, GAFirst renewal noticeBuilt 1973 · S/N 15074480N19558Moon Jonathan E · Butler, PABuilt 1973 · S/N 15074485N19564Priewe Jeff C · Como, MSBuilt 1973 · S/N 15074489N19568June Richard · Stevenson Ranch, CABuilt 1973 · S/N 15074492N19572Borzoya Aero Group Inc · Slatington, PABuilt 1973 · S/N 15074496N19582Olson Ben A · Gig Harbor, WABuilt 1973 · S/N 15074505N19587Steward Matthew C A · Broken Arrow, OKBuilt 1973 · S/N 15074509N19588Kenner David · Maddock, NDS/N 15074510N19589Eaton William I Jr · Seabrook, NHBuilt 1973 · S/N 15074511N19590Koskan John M · Wood, SDBuilt 1973 · S/N 15074512N19592Aviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1973 · S/N 15074514N19594Jeter Ray E · Spring Hill, FLS/N 15074516N19597Estrada Katrina · Helotes, TXBuilt 1973 · S/N 15074519N1970MAirborne Resources Inc · Midlothian, TXBuilt 1971 · S/N A1500300N1975TCharnes Jonathan Edan · Elmwood Park, ILBuilt 1975 · S/N A1500587N1976HOkaeronut LLC · Ponca City, OKBuilt 1975 · S/N 15077112N197KSOld Goat LLC · Wilmington, DEBuilt 1971 · S/N 15072697N197THN197th LLC · Sammamish, WABuilt 1977 · S/N 15280093N1KBThibault Ryan D · Anchorage, AKBuilt 1967 · S/N 15067470N1NSEagle Equity Inc · Valparaiso, INBuilt 1973 · S/N 15074284N1TLLewis Thomas A · Roanoke, VABuilt 1974 · S/N 15075710N200RXAndrews Laral B · Portland, ORS/N 15067073N200SDKing Dwayne W · Sutton, AKBuilt 1969 · S/N 15070651N202WPStow Andrew Geoffrey · Peoria, ILS/N 15063024N2034NNorthstar Aviation Leasing LLC · Merritt Island, FLBuilt 1978 · S/N 15282073N2046ULegacy Aviation Foundation Inc · Staten Island, NYBuilt 1975 · S/N 150-76961N208KCAcevedo Adriel · San Antonio, TXS/N 15070435N209TOnele Dennis E · Central City, NES/N 15068531N20CTN20ctid LLC · Pocatello, IDBuilt 1978 · S/N 152-81952N211TSalazar Frank A · Los Angeles, CABuilt 1975 · S/N 15077046N212AFDoolittle Aero LLC · Goodyear, AZS/N 15076277N212MBEuro 2000 Inc · Merritt Island, FLBuilt 1978 · S/N 15279920N2135GCrawford Mark E · Pleasant Ridge, MIBuilt 1970 · S/N 15071682N216CLMisamore Steven Edward · Mount Juliet, TNS/N 15284706N216DVBusch-Joss Elizabeth M · Blue Point, NYBuilt 1977 · S/N 15280927N218JAWildwood Helicopter Co Inc · Wildwood, NJBuilt 1981 · S/N 15285307
Back to AD 2009-10-09 R2