Registered aircraft · 273

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:87-21-07-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:87-21-07-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:87-21-07-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:87-21-07-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:87-21-07-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:87-21-07-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.

N1010FHangar 10 Aviation LLC · Durant, OKS/N 1403-145 N1021N1021 Inc · Wilmington, DEBuilt 1972 · S/N 12016 N102RRMoyer Aviation Ll C · Katy, TXS/N 1477-5 N106FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 1978 · S/N 3305 N107VCLopez Hidaldo Vicente · San Juan, PRBuilt 1960 · S/N 893-1 N10RTBarbers Point Flight School LLC · Kapolei, HIS/N 285 N110WBFerrin Aviation LLC · Rome, GABuilt 1962 · S/N 500B-1203-98 N112AANestor Richard · Portsmouth, NHBuilt 1964 · S/N 1436-153 N114MNSutton Aircraft Salvage LLC · Palmer, AKBuilt 1965 · S/N 1553-107 N1151ZRenfro Michael W · Bethel, AKS/N 1524-186 N1165ZRegistration Pending · Las Cruces, NMRegistration pendingBuilt 1965 · S/N 1555-198 N1169Downes Pamela · Chino Hills, CABuilt 1956 · S/N 390 N1176ZAirborne Support Inc · Bourg, LABuilt 1965 · S/N 500-B-1549-196 N1187DCordero Miguel · Hollywood, FLS/N 680-626-252 N118PWCentral Airlines Inc · Fairway, KSBuilt 1964 · S/N 1460-163 N11LWilkins Daryl J · Linden, CABuilt 1953 · S/N 520-109 N1203NBracy Rodney E · Middleville, MIBuilt 1972 · S/N 12046 N121SPFl280 LLC · Deland, FLBuilt 1960 · S/N 500B-984-25 N123HTReyes Carlos E · San Juan, PRS/N 3300 N124JPCommemorative Air Force · Dallas, TXBuilt 1956 · S/N 312 N127KHCentral Airlines Inc · Leawood, KSBuilt 1961 · S/N 500B-1027-38 N129MBYellowfin Air Services LLC · Wilmington, DEBuilt 1971 · S/N 3108 N131JTCentral Airlines Inc · Leawood, KSBuilt 1964 · S/N 1468-166 N138KSouth Bay Aviation Inc · Torrance, CAS/N 720-621-2 N147FBrown Helicopter Inc · Pensacola, FLBuilt 1964 · S/N 1432-152 N14FFK & L Agri Farms Inc · Adams, NEBuilt 1961 · S/N 560F-1107-31 N151LTBoss Dog LLC · Sheridan, WYBuilt 1963 · S/N 1316-125 N1525Aviaton Business Corporation · Saint Louis, MOBuilt 1973 · S/N 12022 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 N165KMowbray Aviation Inc · Reno, NVBuilt 1963 · S/N 680F-1252-126 N16JCRl Equipment And Services LLC · Monument, COBuilt 1972 · S/N 3128 N171ZCaribbean Flyers LLC · New York, NYBuilt 1964 · S/N 1450-159 N17DLPonderosa Aviation LLC · Safford, AZBuilt 1969 · S/N 1866-42 N180GAda Forestry Division · Malvern, ARBuilt 1964 · S/N 1438-154 N1938SCavu Aviation LLC · North Yarmouth, MEBuilt 1973 · S/N 3167 N194ZUsda Forest Service Fepp · Malvern, ARBuilt 1965 · S/N 1510-182 N198JWGarrison William E · Nickerson, KSBuilt 1962 · S/N 680F-1132-75 N199WMJetstream Ltd · Powell, OHBuilt 1964 · S/N 1406-59 N19KDFlabob Airport LLC · Riverside, CAS/N 520-29 N202JHPerrin Michel · Austin, TXBuilt 1973 · S/N 3145 N207ACSunflower Aerospace Holdings LLC · Shawnee Mission, KSS/N 500A-1266-89 N210HDPonderosa Aviation LLC · Safford, AZBuilt 1969 · S/N 1841-33 N214JADer Aviation LLC · Dover, TNS/N 3122 N222LEHigh View Air LLC · Driftwood, TXBuilt 1965 · S/N 1525-187 N222WLAirborne Solutions Group · Dayton, OHBuilt 1962 · S/N 560F-1243-53 N22MQCimarron Aviation LLC · Oklahoma City, OKS/N 500A-1271-94 N233WMBosco 74 LLC · Wilmington, DES/N 3313

Back to AD 87-21-07 R1