Skip to content

Registered aircraft · 6,916

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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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.

N7404PWhisler Greg A · Lincoln, NEBuilt 1961 · S/N 24-2589 N7404YSlowpoke Air LLC · Palm Harbor, FLBuilt 1964 · S/N 30-463 N7405PClassic World Holdings LLC · Wilmington, DES/N 24-2590 N7406PAviation Collective LLC · Fort Worth, TXBuilt 1961 · S/N 24-2593 N7406YTucker Engineering Associates Inc · Locust, NCS/N 30-465 N7408PJeffrey Thomas James · Crestwood, KYBuilt 1961 · S/N 24-2595 N7409PPeters Gordon J · Salem, ORBuilt 1961 · S/N 24-2596 N740WTCentral Valley Flight School LLC · Hanford, CABuilt 1969 · S/N 28R-31029 N7410YDuncan Paul J · Bartlett, TNBuilt 1964 · S/N 30-472 N7412PEspyess Aviation LLC · Sylvania, OHBuilt 1961 · S/N 24-2600 N7413YOutka Air LLC · Aberdeen, SDBuilt 1964 · S/N 30-475 N7416PDavenport Jimmy J · Hayesville, NCBuilt 1961 · S/N 24-2604 N7417JKeefer James F · Montoursville, PABuilt 1968 · S/N 28R-30759 N7417PWhitewater Aviation Inc · Harrison, OHBuilt 1961 · S/N 24-2605 N7418JCreel Kenneth Darrell · Smithville, TNBuilt 1968 · S/N 28R-30760 N7418YArmbrister Justin R · Blue Ridge, TXBuilt 1964 · S/N 30-482 N7419PBollfrass William Henry III · Rhinelander, WIBuilt 1961 · S/N 24-2607 N741TJJackson Thomas R Jr · Spearfish, SDBuilt 1964 · S/N 30-477 N7420PTurner Bryan R · Corinth, TXBuilt 1961 · S/N 24-2608 N7420YLegacy Aviation Inc · Stuart, FLBuilt 1964 · S/N 30-484 N7421JBaker Ronald A · Belgrade, MTBuilt 1968 · S/N 28R-30764 N7421YHinkle Anthony Gray · Mineola, TXBuilt 1964 · S/N 30-486 N7424PHutcheson Raymond E · Lawrence, INBuilt 1961 · S/N 24-2612 N7425PRiffle Christopher B · Altus, OKBuilt 1961 · S/N 24-2613 N7426PNehus Christopher J · Camarillo, CABuilt 1961 · S/N 24-2614 N7429PSwett Frank M · Zebulon, NCBuilt 1961 · S/N 24-2617 N7429YDewitt Troy C · Lake Elmo, MNBuilt 1964 · S/N 30-489 N742CSSnider William A · Hye, TXBuilt 1973 · S/N 34-7450065 N7430PSchlosser Nelson L · Tucson, AZBuilt 1961 · S/N 24-2618 N7430YLavion LLC DBA · Zeeland, MIBuilt 1964 · S/N 30-491 N7431JHemmings Jack · North Vernon, INBuilt 1968 · S/N 28R-30775 N7431YRegistration Pending · Lynchburg, VARegistration pendingBuilt 1964 · S/N 30-492 N7432JSingcharoen Kitikorn T · Riverside, CABuilt 1968 · S/N 28R-30776 N7433JYawn Charles L Jr · Denham Springs, LABuilt 1968 · S/N 28R-30778 N7435YStc Aviation LLC · Wilmington, DEBuilt 1964 · S/N 30-498 N7437JSchuch Rick J · Gays Mills, WIBuilt 1968 · S/N 28R-30782 N7437PJohnson Stephen A · Huffman, TXBuilt 1961 · S/N 24-2626 N7438JTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1968 · S/N 28R-30783 N7438PGreene Mike A · Corryton, TNBuilt 1961 · S/N 24-2627 N7438YFranklin Aviation Services LLC · Inverness, FLS/N 30-501 N7439PLewis Aaron A · Chino, CABuilt 1961 · S/N 24-2628 N7439YGoethals Robert M · Silverdale, WABuilt 1964 · S/N 30-502 N743EDAir Adventure LLC · Sheridan, WYBuilt 1977 · S/N 28R-7837096 N7440JChagnot Louis P · Tolland, CTBuilt 1968 · S/N 28R-30786 N7440PSutton Aircraft Salvage LLC · Palmer, AKBuilt 1961 · S/N 24-2629 N7441JGuldi James E · Port Orange, FLBuilt 1968 · S/N 28R-30787 N7441YHatton Leslie A · Chesapeake, VAS/N 30-504 N7442PBalske Curt A · Bedford, TXS/N 24-2631 N7442YMy Toys Inc · Jacksonville, FLS/N 30-505 N7443JPiper Aero Adventure LLC · Port Orange, FLBuilt 1968 · S/N 28R-30790

Back to AD 97-01-01 R1