Registered aircraft · 53

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:68-04-04-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:68-04-04-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:68-04-04-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:68-04-04-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:68-04-04-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:68-04-04-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.

N19GLEastern Stearman Inc Trustee · Leesburg, VABuilt 1992 · S/N 2004 N2101UVansurdam John R · Seneca, SCBuilt 1961 · S/N 147 N2115UDengler Steven G · Lopez Island, WAS/N 163 N2129UMarzich Frank M · Rockford, ILBuilt 1962 · S/N 177 N2150UFifty Uniform LLC · Wilmington, DEBuilt 1963 · S/N 306 N2152UBrantly Flyers LLC · Aurora, ORBuilt 1963 · S/N 310 N2171UHillberg David · Fountain Valley, CAS/N 333 N2173UInternational Air Services Inc Trustee · Carson City, NVBuilt 1963 · S/N 335 N2175UOptimus Aircraft Service Inc · Middletown, DEBuilt 1963 · S/N 337 N2179UFlorea Byron · Carencro, LABuilt 1963 · S/N 341 N2191UJohnson Kenneth E · Mahtomedi, MNBuilt 1964 · S/N 402 N2196UZeiner Gary R · Greencastle, INBuilt 1964 · S/N 407 N2236UPrater Jon A · Palm Coast, FLBuilt 1967 · S/N 475 N2238UHewitt Robert E · Bybee, TNBuilt 1968 · S/N 479 N2241ULatimer Mark A · Roanoke, TXBuilt 1968 · S/N 482 N2252USkylake Adventures LLC · Geneva, OHS/N 411 N2257UMurray Richard A · Celina, OHS/N 418 N2259UMyrtle William E · Martinsville, INBuilt 1964 · S/N 421 N2264UJanvrin Jerry M · Buffalo, SDS/N 426 N2270UPrice Keyth E · Ossian, INBuilt 1964 · S/N 433 N2271UHockett James S · Chiloquin, ORBuilt 1964 · S/N 436 N2272USurplus Industrial Materials LLC · Centralia, WAS/N 437 N2277URegistration Pending · Twin Falls, IDRegistration pendingS/N 442 N2284UAttitude Toys LLC · Wilmington, DES/N 454 N2288ULay Jerry K · Minonk, ILBuilt 1966 · S/N 459 N2289UEastern Stearman Inc Trustee · Leesburg, VABuilt 1966 · S/N 460 N2290UVan Surdam John R · Seneca, SCBuilt 1966 · S/N 461 N2291UHines Scott C · Fort Worth, TXBuilt 1966 · S/N 462 N342MLOrlowski Michael A · Gold Hill, NCS/N 343 N383ESDrake Air LLC · Shelbyville, INS/N 344 N400CXCoker Steve L III · Tyler, TXBuilt 1967 · S/N 470 N45448Sorg Dorothy · Elizabethton, TNBuilt 1997 · S/N 2003 N5912XKnutson Wayne R · Thompson, NDS/N 48 N5913XHay Johnny L · Bethel, OHS/N 49 N5914XTamvakis Dimitri · Orlando, FLS/N 50 N5918XRiley Luther R · Chickasha, OKS/N 54 N5931XRotors & Wings LLC · Salem, ILS/N 69 N5945XFarwell Theodore R · Orangeville, PAS/N 83 N5950XWelch Thomas R · Modesto, CAS/N 89 N5976XFandler Frederick · Shady Shores, TXBuilt 1961 · S/N 119 N5985XWestern North Carolina Air Museum · Hendersonville, NCBuilt 1961 · S/N 129 N5986XPanella Benjamin · Wampum, PABuilt 1961 · S/N 130 N5996XBowles Alan B · Georgetown, TXBuilt 1961 · S/N 141 N64ZXOros John L · Port Charlotte, FLS/N 404 N6796DMat-Su Air Service Inc · Willow, AKBuilt 1960 · S/N 5 N6798DBeard Roger D · Mooresville, INBuilt 1959 · S/N 19 N7WEBegley Edward R · Glasgow, KYBuilt 1964 · S/N 432 N8101TWimberly Fred N · Callao, VABuilt 1962 · S/N 190 N8197Walsh Dennis Executor Et Al · Little Falls, NYS/N 74 N888CFJph Aviation LLC · Pittsburgh, PABuilt 1965 · S/N 457

Back to AD 68-04-04 R2