Skip to content

Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N9464THansen Peter J · Collierville, TNBuilt 1960 · S/N 57264 N94651Patrick A Testerman · Maple Grove, MNBuilt 1978 · S/N 18266475 N9465CPottenger Matthew J · Richland, MIBuilt 1955 · S/N 31863 N9465GOsprey Air LLC · Anchorage, AKS/N U20601665 N9465YWof Investments LLC · Dover, DES/N 21064515 N94660Tweed Bradley Steven · Greeneville, TNBuilt 1978 · S/N 18266480 N94669Harvanek Brian R · Sarver, PABuilt 1978 · S/N 18266484 N9466CTappan Zachariah · Fritz Creek, AKBuilt 1955 · S/N 31864 N94671Sky Jaunts LLC · Kalispell, MTBuilt 1978 · S/N 18266485 N94672Cls Contracting LLC · Eureka, MTFirst renewal noticeBuilt 1978 · S/N 18266486 N94673Glaze Roy J · Smyrna, TNBuilt 1978 · S/N 18266487 N9467MSideropoulos Lester G · Knoxville, TNBuilt 1968 · S/N 18258909 N9468CClarkson Darren E · Phoenix, AZS/N 31866 N9468TBas Part Sales LLC · Greeley, COS/N 57268 N9468XBg Family Lp · Edinburg, TXS/N 21057768 N94691Brentco Aerial Patrol Inc · Canton, OHBuilt 1978 · S/N 18266491 N94698Corsa Exotics Inc · South El Monte, CABuilt 1978 · S/N 18266492 N9469GGolf Tango Air Racing LLC · Ephrata, WABuilt 1971 · S/N U20601669 N9469XMurdoch Nathan B · Nehawka, NEBuilt 1961 · S/N 21057769 N9469ZEly John E · Prosser, WAS/N 33940 N946CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282408 N94709South Georgia Technical College · Americus, GABuilt 1978 · S/N 18266496 N9470CLauer William A · Mercer, WIBuilt 1955 · S/N 31686 N9470GDrean Gary T · Rancho Santa Fe, CABuilt 1971 · S/N U20601670 N9470MJanes Dwayne O · Edmond, OKBuilt 1970 · S/N 21059370 N9470XPerry Edward Glen · Brigham City, UTS/N 21057770 N94713Thompson Robert M · Nevada, MOBuilt 1978 · S/N 18266497 N9471XVincent Equipment LLC · Grand Junction, COBuilt 1961 · S/N 21057771 N9472ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 18268417 N9472FJunell Sonny Brian · Midlothian, TXBuilt 1988 · S/N 18280201 N9472MValentine Kurt J · Apple Valley, MNBuilt 1970 · S/N 21059372 N9472TWilliams Chad R · Jamestown, INBuilt 1960 · S/N 57272 N9473CWild America Aviation And Holding Co LLC · Wilmington, DEBuilt 1955 · S/N 31871 N9473MOpie Milton J III · White Lake, MIBuilt 1970 · S/N 21059373 N9473ZGoldstein Jeffrey Edward · Dix Hills, NYBuilt 1998 · S/N 18280165 N9474CAndrews David L · Redvale, COBuilt 1955 · S/N 31872 N9474TWalker James O · Lovell, WYBuilt 1960 · S/N 57274 N9474XKronner Prototypes Inc · Roseburg, ORFirst renewal noticeBuilt 1961 · S/N 21057774 N94751Ishawooa Air LLC · Cody, WYBuilt 1978 · S/N 18266500 N94753Thornton Shawn Wayne · Cheyenne, WYBuilt 1978 · S/N 18266502 N94757Deters John Lloyd · Spring Grove, MNBuilt 1978 · S/N 18266504 N9475CGlover Street Investors LLC · Winthrop, WABuilt 1955 · S/N 31873 N9475FLewis Steve · Canyon, TXBuilt 1998 · S/N 18280153 N9475MRyan Air Inc · Anchorage, AKBuilt 1981 · S/N 20700695 N9475RVon Imhof Rudi F · Anchorage, AKBuilt 1985 · S/N U20606872 N9476FF & M Miya LLC · Hanford, CABuilt 1998 · S/N 18280208 N9476TRegistered aircraftSale reportedBuilt 1960 · S/N 57276 N9476XMcdonald Air LLC · Indianapolis, INBuilt 1985 · S/N 18268536 N94772Kamal Rafi · Mountain View, CABuilt 1978 · S/N 18266507 N9478GExecutive Security Solutions LLC · Moody, ALBuilt 1974 · S/N 18263397

Back to AD 84-10-01 R1