Registered aircraft · 85,620

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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.

N2136JHanus John E · North Kingstown, RIBuilt 1978 · S/N 28-7990219 N2136MWashington Israel · Cincinnati, OHBuilt 1977 · S/N 28-7816253 N2136PTrebbow Mike A · Santa Barbara, CAS/N 28R-7931064 N2136RGibbens John L Trustee · Rock Springs, WYBuilt 1964 · S/N 18255336 N2136WMills Robert D · Newport, MIBuilt 1974 · S/N E-568 N2136YW Tech Consulting Inc · Wilmington, DEBuilt 1979 · S/N 28-7916368 N2136ZPorta Frank T · Charleston, WVBuilt 1979 · S/N 28R-7918111 N21370Garner Jan L · Fremont, OHBuilt 1972 · S/N 18261591 N21372Halbert Ronald S · San Diego, CABuilt 1978 · S/N 32R-7887204 N21374Stratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17263938 N21376Vodry John · Quilcene, WABuilt 1972 · S/N 18261596 N2137FColakoglu Migirdic · Hilton, NYBuilt 1978 · S/N 28-7911048 N2137JAdverse Yaw LLC · Milford, CTBuilt 1978 · S/N 28-7916205 N2137LPcb Air 2 LLC · West Palm Beach, FLBuilt 1976 · S/N CE-662 N2137NTa4 Ventures LLC · Greenwood Village, COS/N 28R-7931049 N2137RFreefall Express Inc · Gardiner, NYBuilt 1964 · S/N 18255337 N2137TWatson Jay C · Midland, TXBuilt 1971 · S/N 28-7105160 N2137YCullinan David · Fryeburg, MEBuilt 1962 · S/N 17249637 N2137ZAnderson Kenneth L · Anchorage, AKBuilt 1963 · S/N 18051237 N21382Rodriguez Carlos Mendoza · Paramount, CABuilt 1978 · S/N 34-7870434 N21389Registration Pending · Waldo, WIRegistration pendingBuilt 1974 · S/N 17263942 N2138DMigliaccio Jason · Palm Bay, FLBuilt 1953 · S/N D-3483 N2138FCima Christopher P · Plano, TXBuilt 1979 · S/N 32R-7987065 N2138GFlorida Aviation Career Training Inc · St Augustine, FLBuilt 1979 · S/N 44-7995191 N2138KGrigsby Aaron A · Victorville, CABuilt 1978 · S/N 32R-7987070 N2138LBrooks John S · Camarillo, CAS/N E-893 N2138NJ T Air Inc · Dayton, MDBuilt 1979 · S/N 28-7911094 N2138RWisdom Victor · Sterling, COBuilt 1965 · S/N 646 N2138SStamm Roy Peter · Woodstock, GABuilt 1975 · S/N 21061099 N21393Dinelli Aviation LLC · Milton, DES/N 18261607 N21395Faignant J Brian Jr · Anchorage, AKBuilt 1972 · S/N 18261608 N21396Greers Banner Air Of Bakersfield Inc · Bakersfield, CABuilt 1972 · S/N 18261609 N21398Peterson Peter M · Silverado, CABuilt 1977 · S/N D-10077 N2139BN2139b LLC · Newark, DEBuilt 1978 · S/N 28-7911009 N2139DJenkins James G · Stoneville, NCBuilt 1953 · S/N D-3484 N2139FCrow Brian M · Oakesdale, WABuilt 1965 · S/N U206-0339 N2139GSoarmates LLC · Missoula, MTBuilt 1958 · S/N 51439 N2139JHotung Lisa M · Amherst, NYBuilt 1978 · S/N 28-7990220 N2139RShaw Gregory A · West Richland, WABuilt 1964 · S/N 18255339 N2139TFlight School Of Gwinnett Inc · Lawrenceville, GABuilt 1971 · S/N 28R-7135145 N2139ZAdkison Todd · Vinemont, ALBuilt 1979 · S/N 28R-7931160 N213ACRtb Transport LLC · Evans, GABuilt 1984 · S/N 31-8452011 N213ANCalifornia In Nice Inc DBA · San Jose, CAS/N 17272380 N213BGUpstate Flyers LLC · Woodruff, SCBuilt 1972 · S/N 18261580 N213BPJim Nichols Air Service LLC · Fincastle, VABuilt 1986 · S/N 28-8690056 N213CLevins Kenneth · Alameda, CABuilt 2006 · S/N 3257436 N213CBSkymates Inc · Wilmington, DEBuilt 2002 · S/N 4496147 N213CHEz Aviation LLC · Morrisville, NCS/N TH-2079 N213CNCullem Daniel F · Soquel, CABuilt 1980 · S/N TC-2298 N213CSAeromarine Airways Inc · Miami, FLBuilt 1978 · S/N 24-0529

Back to AD 98-21-21 R1