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.

N9634XScoggin Gerald William III · Port Saint Lucie, FLBuilt 1962 · S/N 21057934 N9636YCarranza Chris J · Stanfield, AZBuilt 1981 · S/N 21064566 N9637XCypress Peak LLC · Pickens, MSBuilt 1962 · S/N 21057937 N9638XPiper Earl Holdings LLC · Newark, DEBuilt 1986 · S/N 18268572 N96393Graham Eric H · Johnson City, TXBuilt 1978 · S/N 18266705 N9639XFerguson John · Montrose, COS/N 21057939 N963CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281973 N96403Skylens LLC · Hammond, LABuilt 1978 · S/N 18266708 N9640BHanson Glen W · Anchorage, AKBuilt 1957 · S/N 32937 N9640QFour Zero Quebec Inc · Cheyenne, WYBuilt 1969 · S/N 18259642 N9640TJohnson Joshua S · Lake Jackson, TXBuilt 1960 · S/N 57440 N96410Penny John C Jr · Sterling, COBuilt 1978 · S/N 18266709 N96411Zz Top Rentals Inc · Missoula, MTBuilt 1978 · S/N 18266710 N96416Wolstenholme Ralph E · Westfield, PABuilt 1978 · S/N 18266713 N96418Twin City Cloud 7 Inc · Eden Prairie, MNBuilt 1978 · S/N 18266714 N96419Thompson Steven · Rockwall, TXBuilt 1978 · S/N 18266715 N9641BFlying Brown Dog LLC · Boulder, COBuilt 1957 · S/N 32938 N9641ZWhitehead Michelle W · Centralia, WABuilt 1982 · S/N U20606592 N9642TDavidow Clifford A · Portland, ORBuilt 1960 · S/N 57442 N9643TDunn Meghan Elizabeth · Mckinney, TXBuilt 1960 · S/N 57443 N9643ZAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1982 · S/N U20606594 N9644GKatmai Air LLC · Anchorage, AKS/N U20601844 N9644TFloyd Andrew W · Mesa, AZBuilt 1960 · S/N 57444 N96455Haeussler Arne · Chandler, AZBuilt 1978 · S/N 18266726 N9645GConnolly Michael T · Ferndale, WABuilt 1974 · S/N 18263413 N9645XCall The Ball Aviation LLC · Phoenix, AZS/N 21057945 N96462Skylens LLC · Hammond, LABuilt 1978 · S/N 18266728 N9646XKomko Randy M · Mckenna, WABuilt 1962 · S/N 21057946 N96474Skylane 4 LLC · Leesburg, FLBuilt 1978 · S/N 18266730 N96475Gregg Flying Service Inc · Durango, COBuilt 1978 · S/N 18266731 N96476After Global Holdings Corp · Wichita, KSBuilt 1978 · S/N 18266732 N96480Mfkc182 LLC · Lantana, TXBuilt 1978 · S/N 18266733 N9648XWilt Michael J · Windham, NHBuilt 1962 · S/N 21057948 N96490Schabacker Charles W · Jerome, IDBuilt 1978 · S/N 18266737 N96491Registered aircraftBuilt 1978 · S/N 18266738 N9649GAllen Todd N · Mccall, IDBuilt 1977 · S/N U20603819 N9649XRp Aviation LLC · Plattsmouth, NEBuilt 1986 · S/N 18268577 N964AC63 Victor LLC · Fremont, OHBuilt 1999 · S/N 20608073 N964AFBoerner Robert L Trustee · El Cajon, CABuilt 1972 · S/N 18261562 N964CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282410 N964TMByrd Properties LLC · Olathe, KSBuilt 1978 · S/N 18266722 N964WFTempietto Inc · Aptos, CABuilt 2003 · S/N 18281291 N96500Granado Jose Jr · Chandler, AZBuilt 1979 · S/N 18266741 N96505Price James Wilson · Big Stone Gap, VAS/N 18266744 N96509Aircraft Equities Inc · Wilmington, DEBuilt 1978 · S/N 18266745 N9650XJorsey Elizabeth A · Reidsville, NCBuilt 1962 · S/N 21057950 N96510T34b LLC · Seattle, WABuilt 1978 · S/N 18266746 N96515Harrill David H · Charlotte, NCBuilt 1978 · S/N 18266748 N96516Quanz Bernard A · Wayland, NYBuilt 1978 · S/N 18266749 N9651MGrant Aviation Inc · Anchorage, AKBuilt 1981 · S/N 20700715

Back to AD 84-10-01 R1