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.

N60630Bichell Kevin C · Corsicana, TXBuilt 1969 · S/N 15070461 N60632Lawlyes Bill · Aguanga, CABuilt 1969 · S/N 15070463 N60633Newby Terry · Kokomo, INBuilt 1969 · S/N 15070464 N60639International Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 15070468 N6063LLargent Ronald D · Sayre, OKBuilt 2000 · S/N 5421 N6063RGarcia Pinedo Adolfo · Miami, FLBuilt 1965 · S/N 17253732 N6063TMid Florida Chapter 534 · Leesburg, FLBuilt 1964 · S/N 15060763 N60640Lazarus Benjamin · Blaine, WAS/N 15070469 N60641Motory Group LLC · Alachua, FLBuilt 1969 · S/N 15070470 N60649Anglin Cheryl L · Jackson, MSFirst renewal noticeBuilt 1969 · S/N 15070477 N6064JTreger Mark · Dallas, TXFirst renewal noticeBuilt 1972 · S/N A1500364 N6064TEsquivel Francisco · Thermal, CAS/N 15060764 N60650St Arneault Carmen M · Milton, NHBuilt 1969 · S/N 15070478 N60652Broughton Stanley K · Salt Lick, KYBuilt 1969 · S/N 15070479 N60653Russo Joseph M · Pleasant Grove, CABuilt 1969 · S/N 15070480 N6065AMam Air LLC · Stone Creek, OHBuilt 1956 · S/N 28665 N6065JBrown Charles A · Boise, IDBuilt 1972 · S/N A1500365 N6065KMiller Durwood B · Screven, GABuilt 1975 · S/N 15077505 N6066AAndrews Peter F · Rangeley, MEBuilt 1956 · S/N 28666 N6066GGisselman Scott D · Lago Vista, TXBuilt 1969 · S/N 15071566 N6066TDonaldson Ted · Thatcher, AZBuilt 1964 · S/N 15060766 N6067GWildroot Aviation LLC · Bellingham, WABuilt 1969 · S/N 15071567 N6067JSale Reported · Ephrata, WASale reportedBuilt 1972 · S/N A1500367 N6067RZhu Kevin · Tigard, ORBuilt 1965 · S/N 17253736 N60681Hendrickson Robert T · Galesburg, ILS/N 15070496 N60682Sweeney Andrew H · Murray, KYBuilt 1969 · S/N 15070497 N60684Gunnarsson Elliott Gudni · Concrete, WABuilt 1969 · S/N 15070499 N60685Barton Steven Lewis · Ventura, CABuilt 1969 · S/N 15070500 N60687Luse Benjamin T · Newalla, OKBuilt 1969 · S/N 15070501 N6068AWillerscheidt Thomas H · Mukwonago, WIBuilt 1956 · S/N 28668 N6068GWilliams Daniel E Jr · Morehead City, NCS/N 15071568 N60693Conaway David J · Orange Park, FLBuilt 1969 · S/N 15070506 N60694Hodgkinson David · Tolland, CTBuilt 1969 · S/N 15070507 N606CCMoore Thomas · Tecumseh, MIBuilt 2007 · S/N CC11-00039 N606EHFlannigan Robert B · Ashland, MSBuilt 2010 · S/N 277 N606JCAsencio Garcia Enrique R · Fort Worth, TXBuilt 1976 · S/N 15078753 N606RJJohnson Eric O · Sallisaw, OKBuilt 2006 · S/N CC11-00003 N606SCAlpha Charlie Aviation LLC · Oregon City, ORBuilt 2011 · S/N 16200175 N60701Nichols Daniel H · Helen, GAFirst renewal noticeBuilt 1969 · S/N 15070511 N60704Discover Aviation LLC · Unionville, MOS/N 15070512 N60708Registration Pending · Wentworth, MORegistration pendingS/N 15070515 N6070APolin Keith A · Belen, NMS/N 28670 N6070GSimpson Michael · Chateaugay, NYBuilt 1969 · S/N 15071570 N6070RHodgson E Russell · Nevada City, CABuilt 1965 · S/N 17253739 N60714Yoder Frederick David · Wellington, FLBuilt 1969 · S/N 15070520 N60716Evans Michael J · Greenville, MIBuilt 1969 · S/N 15070522 N6071AJones Jane · Portland, ORBuilt 1956 · S/N 28671 N6071KBlumhagen Myron M · Drake, NDBuilt 1975 · S/N 15077509 N60720Sedlak Christopher T · Lake City, FLBuilt 1969 · S/N 15070526 N60729Parry Peter S · New Kent, VABuilt 1969 · S/N 15070530

Back to AD 94-05-05 R1