Skip to content

Registered aircraft · 26,230

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.

N1140YPritchard Casey M · Bells, TXBuilt 1962 · S/N 15059540 N11410South Florida Helicopters Inc · Indiantown, FLS/N 15075399 N11416Woodward Stephen W · Westfield, NYBuilt 1973 · S/N 15075404 N1141DKilo Mushroom Aeronautics Inc · Renton, WABuilt 1951 · S/N 15704 N1141EGuttormson Gene A · Georgetown, MNBuilt 1946 · S/N 7AC-4697 N1142DSale Reported · Fayetteville, WVSale reportedBuilt 1951 · S/N 15705 N1142FHart James A · Arlington, VAFirst renewal noticeBuilt 1966 · S/N 17254737 N1142HSimmons Donald E · Clifton Park, NYBuilt 1948 · S/N 15AC-153 N11430De Alwis Godalle W · Riverside, CABuilt 1973 · S/N 15075414 N11433Jedi Flight Training LLC · Boerne, TXBuilt 1973 · S/N 15075416 N1143BBaker Joseph P · Matthews, NCBuilt 1947 · S/N 5770 N1143DSwanland Robert C · San Jose, CABuilt 1951 · S/N 15706 N1143FWilson Dan · Saginaw, TXS/N 17254738 N1143VDevine Patrick · Weldon Spring, MOBuilt 1956 · S/N 47970 N11442Burkholder Donald R · Kent, OHS/N 15075424 N11444Aerojet Services Inc · Poplar Grove, ILBuilt 1931 · S/N 3495 N1144YThomas Douten D · Roxbury, MES/N 15059544 N11452Schatz Michael J · Myerstown, PABuilt 1973 · S/N 15075433 N11454Wausau Flying Service Inc · Wausau, WIBuilt 1973 · S/N 15075434 N1145KSheehan Sean M · Hampstead, NCBuilt 1946 · S/N 3872 N11460Kalmar Peter · Suquamish, WABuilt 1973 · S/N 15075439 N1146FLarson Larry D · Sargeant, MNBuilt 1966 · S/N 17254741 N11479Lucky Duck Aviation LLC · Palm City, FLBuilt 1973 · S/N 15075450 N1147FParker Robert M · Hurst, TXBuilt 1966 · S/N 17254742 N1147QGraber Quinten R · Brooksville, MSBuilt 1947 · S/N 12785 N11485Foster Harold · Natchitoches, LABuilt 1973 · S/N 15075453 N11488Cooker Keith P · Greenville, SCBuilt 1973 · S/N 15075456 N1148DBohl Howard M · Temecula, CABuilt 1951 · S/N 15711 N1148FReed Roger · Lebanon, KYBuilt 1966 · S/N 17254743 N1148HReed Charles H · Shelbyville, KYBuilt 1948 · S/N 15AC-163 N11491Jamieson Donald R · Condon, ORS/N 15075458 N11492Mccroan James H · Altha, FLBuilt 1973 · S/N 15075459 N11493Wajih Al Habbal · Simi Valley, CABuilt 1973 · S/N 15075460 N1149911499 LLC · Oklahoma City, OKS/N 15075464 N1149FLemery Aaron D · Chattaroy, WAS/N 17254744 N114LCCameron John B · Iredell, TXS/N AL-1140 N11501Erickson Kirk E · Warroad, MNBuilt 1973 · S/N 15075466 N11507Strickland Jed B · Bald Knob, ARBuilt 1973 · S/N 15075472 N1150DFlight Time Pathways · Forest Lake, MNBuilt 1951 · S/N 15713 N1150LNida Kevin R · Santa Paula, CAS/N 15073274 N1150YHoffman Anthony J · Rathdrum, IDBuilt 1962 · S/N 15059550 N11510Falls Aero Inc · Great Falls, MTBuilt 1973 · S/N 15075473 N11513Erickson Tristan Scott · Port Townsend, WABuilt 1973 · S/N 15075475 N11514Kickstart Aviation LLC · Mayfield, KYBuilt 1974 · S/N 15075476 N11517Grier Robert M · Deland, FLS/N 15075479 N11519Kap Title Inc · Tucker, GABuilt 1973 · S/N 15075481 N1151BOrtiz Daniel · Edinburg, TXBuilt 1973 · S/N 15075478 N1151DWelborn Mark G · Boonville, NCBuilt 1951 · S/N 15714 N1151PPapich George J · Sonoma, CAFirst renewal noticeS/N L2 N1151YCraigmyle William R · Cooperstown, NYBuilt 1962 · S/N 15059551

Back to AD 94-05-05 R1