Skip to content

Registered aircraft · 120

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:61-14-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:61-14-01') 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:61-14-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:61-14-01')
  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:61-14-01')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:61-14-01')
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.

N1010FHangar 10 Aviation LLC · Durant, OKS/N 1403-145 N107VCLopez Hidaldo Vicente · San Juan, PRBuilt 1960 · S/N 893-1 N110WBFerrin Aviation LLC · Rome, GABuilt 1962 · S/N 500B-1203-98 N112AANestor Richard · Portsmouth, NHBuilt 1964 · S/N 1436-153 N1151ZRenfro Michael W · Bethel, AKS/N 1524-186 N1165ZRegistration Pending · Las Cruces, NMRegistration pendingBuilt 1965 · S/N 1555-198 N1176ZAirborne Support Inc · Bourg, LABuilt 1965 · S/N 500-B-1549-196 N118PWCentral Airlines Inc · Fairway, KSBuilt 1964 · S/N 1460-163 N121SPFl280 LLC · Deland, FLBuilt 1960 · S/N 500B-984-25 N127KHCentral Airlines Inc · Overland Park, KSBuilt 1961 · S/N 500B-1027-38 N131JTCentral Airlines Inc · Overland Park, KSBuilt 1964 · S/N 1468-166 N147FBrown Helicopter Inc · Pensacola, FLBuilt 1964 · S/N 1432-152 N151LTBoss Dog LLC · Sheridan, WYBuilt 1963 · S/N 1316-125 N152KWestern Capital Partners LLC · Wilmington, DEBuilt 1962 · S/N 500A-1258-82 N159KIsland Hopper Air LLC · Ponte Vedra Beach, FLBuilt 1959 · S/N 751 N160XMalolo LLC · San Luis Obispo, CAS/N 500B-1300-115 N161BLAirborne Holdings Inc · Midlothian, TXBuilt 1965 · S/N 1551-197 N171ZCaribbean Flyers LLC · New York, NYBuilt 1964 · S/N 1450-159 N180GAda Forestry Division · Malvern, ARBuilt 1964 · S/N 1438-154 N194ZUsda Forest Service Fepp · Malvern, ARBuilt 1965 · S/N 1510-182 N207ACSunflower Aerospace Holdings LLC · Shawnee Mission, KSS/N 500A-1266-89 N222LEHigh View Air LLC · Driftwood, TXBuilt 1965 · S/N 1525-187 N22MQCimarron Aviation LLC · Oklahoma City, OKS/N 500A-1271-94 N234WMBay Area Skymaster LLC · Pasadena, MDBuilt 1962 · S/N 500A-1257-81 N23BQCentral Airlines Inc · Overland Park, KSBuilt 1961 · S/N 500A-1065-46 N261ERCentral Airlines Inc · Overland Park, KSBuilt 1963 · S/N 1362-133 N272CACentral Airlines Inc · Leawood, KSBuilt 1964 · S/N 1409-146 N274LECsonka Bela · Hesperia, CABuilt 1962 · S/N 500A-1232-69 N289GRAerocomm LLC · Kalispell, MTBuilt 1959 · S/N 795 N304JTCentral Airlines Inc · Overland Park, KSBuilt 1965 · S/N 1494-175 N311PWQuantic LLC · Morrisville, NCBuilt 1961 · S/N 500A-1106-54 N312ECAmy Johan J · Coral Springs, FLBuilt 1958 · S/N 676-27 N313MBosco74 LLC · Wilmington, DEBuilt 1963 · S/N 500A-1276-99 N324RRCentral Airlines Inc · Overland Park, KSBuilt 1964 · S/N 1386-139 N329RSTeichman David · Dade City, FLBuilt 1963 · S/N 1303-118 N333BENtn3n LLC · Titusville, FLBuilt 1960 · S/N 500A-979-33 N346UDJack W Berry And Associates Inc · Peachtree City, GABuilt 1965 · S/N 1539-193 N353CCThree Jay Enterprises LLC · Los Altos, CABuilt 1962 · S/N 500B-1230-105 N37CKSale Reported · Saint Thomas, VISale reportedBuilt 1962 · S/N 500A-1251-76 N3836CAdvanced Airways Inc · Loxahatchee, FLS/N 791 N411ETCentral Airlines Inc · Overland Park, KSBuilt 1966 · S/N 1621-214 N411FSRomain Bevin G · St Thomas, VIBuilt 1962 · S/N 1162-85 N411JFCentral Airlines Inc · Overland Park, KSS/N 500B-1014-35 N411PTCentral Airlines Inc · Leawood, KSBuilt 1962 · S/N 500B-1207-99 N415BHCentral Airlines Inc · Overland Park, KSBuilt 1960 · S/N 500B-918-5 N443WACentral Airlines Inc · Overland Park, KSBuilt 1963 · S/N 1315-124 N444BDAddington James T · Denton, TXBuilt 1960 · S/N 94629 N444CACentral Airlines Inc · Leawood, KSBuilt 1964 · S/N 1458-162 N444CBCentral Airlines Inc · Overland Park, KSBuilt 1961 · S/N 500B-1119-69 N444WAWiseman Aviation Inc · Flagstaff, AZBuilt 1961 · S/N 1130-60

Back to AD 61-14-01