Skip to content

Registered aircraft · 26,232

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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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:94-05-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
  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:94-05-05-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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.

N6083RHatle Arlen J · Meadow, SDFirst renewal noticeBuilt 1965 · S/N 17253752 N60846Erickson Daniel W · Tomales, CAS/N 15070615 N6084JHatloy Mark · Drayton, NDBuilt 1973 · S/N A1500384 N6084TRipper Ryan · Howell, MIBuilt 1964 · S/N 15060784 N6084VElmore Jerry R Jr · Wichita, KSBuilt 1956 · S/N 47-1244 N60855Douglas Raymond M · Hamilton, NYBuilt 1969 · S/N 15070622 N6085TUllmayer Claressa L · Murray, UTBuilt 1964 · S/N 15060785 N6085VObrien Stephen F · Manley, AKBuilt 1948 · S/N 7CCM-36 N60860Joebravo Aviation LLC · Derby, KSBuilt 1969 · S/N 15070627 N60861Hansen Aviation LLC · Savannah, GAS/N 15070628 N60865Breitberg Benjamin D · Ridgecrest, CABuilt 1969 · S/N 15070631 N6086AWatson Johnna A · Sonoma, CABuilt 1956 · S/N 28686 N6086TCampbell Jack G · Spring Valley, WIBuilt 1964 · S/N 15060786 N60870Stracener Adam K · Pittsburg, TXBuilt 1969 · S/N 15070635 N60875Registration Pending · Soldotna, AKRegistration pendingBuilt 1969 · S/N 15070638 N60878Barnett Shawn N · Hartsfield, GABuilt 1969 · S/N 15070639 N6087AFlood Plain Farm And Mercantile LLC · Curlew, WABuilt 1956 · S/N 28687 N6087JTexas Youth Flight Experience Foundation · Boerne, TXBuilt 1973 · S/N A1500387 N6087RPalmenteri Winston D · Rhome, TXS/N 17253756 N6087TGray Bryan D · Colorado City, TXBuilt 1964 · S/N 15060787 N60880Walsh Michael B · Gates, TNBuilt 1969 · S/N 15070641 N60883Dubaj Louis F · Spring Hill, FLBuilt 1969 · S/N 15070644 N60884Norton Keith H · Oro Valley, AZBuilt 1969 · S/N 15070645 N60888Somerville Nicholas · Saint Augustine, FLBuilt 1969 · S/N 15070647 N60889Law Offices Of Shawn A Mcmillan Apc · San Diego, CABuilt 1969 · S/N 15070648 N6088AStrickland Vernon G · Fort Worth, TXBuilt 1956 · S/N 28688 N6088GGreat Lakes Air Ventures LLC · Mason, MIBuilt 1969 · S/N 15071588 N6088RPruette Jason · Oakland, CABuilt 1965 · S/N 17253757 N60892Moyers Steven J · Carrollton, KYBuilt 1969 · S/N 15070650 N60899Flight Services Inc · Headland, ALBuilt 1969 · S/N 15070654 N6089RLeadbetter Roy A · Georgetown, TXS/N 17253758 N608BBMote Darren Lee · Corcoran, MNBuilt 2008 · S/N CC11-00066 N609033bs Land Development LLC · Seattle, WABuilt 1969 · S/N 15070657 N6090ARegistered aircraftBuilt 1956 · S/N 28690 N6090RPaul Rowe Memorial Airport Association Inc · Kahoka, MOBuilt 1965 · S/N 17253759 N60912Krogh Zachary H · Mc Laughlin, SDBuilt 1969 · S/N 15070663 N60916Webb Hunter · Altamont, UTBuilt 1969 · S/N 15070666 N60919Lassie Lite LLC · Rhinebeck, NYBuilt 1969 · S/N 15070669 N6091ABarrientos Jeri · Collinsville, OKS/N 28691 N6091CPatterson Randall E · Palm Coast, FLBuilt 1947 · S/N 47-1124 N6091GAkin Evrin · Newport Beach, CABuilt 1969 · S/N 15071591 N6091TDyck David C · Lake Forest Park, WABuilt 1964 · S/N 15060791 N60926Watson Stephen A · Scottsdale, AZBuilt 1969 · S/N 15070673 N6092GComeau Charles · Brimfield, MABuilt 1969 · S/N 15071592 N6092RBrock Roy C Jr · Pilot Point, TXBuilt 1965 · S/N 17253761 N6092TPurkinje Ltd LLC · Wilmington, DEBuilt 1964 · S/N 15060792 N60930Time Machine LLC · Kailua Kona, HIBuilt 1969 · S/N 15070674 N6093ARecker Nicholas P · Franklin, TNBuilt 1956 · S/N 28693 N6093CHansen Evan P · Stevens Point, WIBuilt 1956 · S/N 47-1201 N6093GCaylin LLC · Wilmington, DEBuilt 1969 · S/N 15071593

Back to AD 94-05-05 R1