Skip to content

Registered aircraft · 56,580

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N292DAIndependence Youth Flying Club Inc · Independence, ORBuilt 1966 · S/N 17255066 N292EDL1 Aviation LLC · Sparks, NVBuilt 2002 · S/N 172S9105 N292KFTotal Flight Aircraft Leasing LLC · Apex, NCS/N 17268188 N292MAHot Tails LLC · Richmond, MOBuilt 1998 · S/N 18280174 N292PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2022 · S/N 172S12866 N292PZMalone Patrick A · Tuscumbia, ALS/N 185-0375 N292SPMonmouth Aircraft Service Inc · Toms River, NJBuilt 2003 · S/N 172S9477 N292TCRich Daniel W · Norton, MABuilt 2002 · S/N 172S9122 N292TFTextron Aviation Inc · Wichita, KSS/N 172S13610 N292VFTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2025 · S/N 172S13349 N293Zer Holdings LLC · Woodinville, WABuilt 1975 · S/N P3370226 N29307Lacroix Michael G Trustee · Shorewood, MNBuilt 1968 · S/N 17700803 N2930DGuerin Stephen · Lyme, NHBuilt 1955 · S/N 26873 N2930EKelly Ronald T Jr · Munhall, PABuilt 1978 · S/N 17271375 N2930FWrucke Scott · Horicon, WIBuilt 1966 · S/N 18257030 N2930JTetil Nicholas M · Fairgrove, MIBuilt 1966 · S/N 15065730 N2930UWeast Michael D · Artesia, NMBuilt 1963 · S/N 17250530 N2930XAero Dynamics Flying Club Inc · Mulino, ORBuilt 1968 · S/N 17700330 N2931AStrategic Aircraft Management LLC · Fairbanks, AKBuilt 1953 · S/N 30131 N2931EHoward Charles O · Sonoma, CABuilt 1978 · S/N 17271376 N2931HAtp Aircraft 7 LLC · Wilmington, DEBuilt 2006 · S/N 172S10400 N2931JSmith William T · Fort Payne, ALBuilt 1966 · S/N 15065731 N2931ULudwig Alfred R · Hayward, CABuilt 1963 · S/N 17250531 N2931XRegistered aircraftBuilt 1967 · S/N 17700331 N2931YWiesner Norman P Trustee · Silverton, ORBuilt 1962 · S/N 18253931 N29320Triple G Aviation LLC · South Point, OHBuilt 1968 · S/N 17700810 N29321Render Jeff · Peoria, ILBuilt 1968 · S/N 17700811 N29329Hill Edward J Jr · Dover, DEBuilt 1968 · S/N 17700815 N2932AHenderson Steven A · Idaho Falls, IDBuilt 1953 · S/N 30132 N2932DDont Make Things Difficult LLC · Downers Grove, ILS/N 26875 N2932SRutoski Mary Ann · Jordan, MNBuilt 1967 · S/N 15066832 N29330Rucinski Edward A · Climax, NCBuilt 1968 · S/N 17700816 N29334Burger Cale L · Hampden, MEBuilt 1968 · S/N 17700820 N29335Sale Reported · Lebanon, ORSale reportedBuilt 1968 · S/N 17700821 N2933CLawson Matt E · Gobles, MIS/N 30833 N2933FLevinsohn Reuben D · East Lansing, MIBuilt 1966 · S/N 18257033 N2933SHarry Kevin M · Salisbury, NCBuilt 1967 · S/N 15066833 N29340Hodges Michael T · Myrtle Beach, SCBuilt 1968 · S/N 17700823 N29343Aeromech Incorporated · Mukilteo, WABuilt 1968 · S/N 17700826 N29344P & P Aviation LLC · Trout Run, PAS/N 17700827 N29345Bailey Daniel L · Gibsonville, NCBuilt 1968 · S/N 17700828 N2934ADixon Devin M · Las Vegas, NVBuilt 1953 · S/N 30134 N2934DHennis Jess L · Cottonwood, IDBuilt 1955 · S/N 26877 N2934FH & S Aviation LLC · Roseville, MNBuilt 1966 · S/N 18257034 N2934ULison Denis Gregory · Hollis, NHBuilt 1963 · S/N 17250534 N2934YOwens John A · Granville, OHBuilt 1962 · S/N 18253934 N29350Cardinal Flyers LLC · Amherst, VAS/N 17700833 N29356Rohwer Celia · Fairbanks, AKBuilt 1968 · S/N 17700836 N29359Cervantes Jose DBA · San Diego, CABuilt 1973 · S/N 21059858 N2935CSuez Jose F · Tracy, CABuilt 1954 · S/N 30835

Back to AD 79-10-14 R1