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.

N1445SHagemann Karl B · Santa Clarita, CABuilt 1976 · S/N 18264993 N1445TWhelan And Sons Realty LLC · Suffield, CTBuilt 1972 · S/N 28R-7235290 N1445YSwartz Steven L · Nashville, TNBuilt 1962 · S/N 17249145 N1446GHangar 46 LLC · Garden City, KSS/N CD-460 N1446XN15956 Inc · Wilmington, DEBuilt 1975 · S/N 28-7525317 N1446YWise Ron · Napoleon, OHBuilt 1962 · S/N 17249146 N14472Hoerler Jonathan · Lincoln, ARBuilt 1963 · S/N 18255194 N1447DSimmons Dennis L · Wichita, KSS/N 20030 N1447FCook David F · Carthage, MOBuilt 1966 · S/N 17254942 N1447GMutz Richard Douglas Jr · Rockledge, FLBuilt 1962 · S/N CD-461 N1447HMarkovich David E · Eden Prairie, MNBuilt 1977 · S/N 28-7725144 N1447SRegistered aircraftFirst renewal noticeBuilt 1976 · S/N 18264995 N1447TDa Silva Paulo E · Orlando, FLS/N 28R-7235292 N1447XGaventa Edward J · Logan Twp, NJBuilt 1975 · S/N 28-7525318 N14483Amar John D · Las Vegas, NVBuilt 1976 · S/N 22-1405 N1448GMotions Dynamics LLC · Campbellsville, KYBuilt 1962 · S/N D-6916 N1448SWild Heart Springs LLC · Wilder, IDBuilt 1976 · S/N 18264996 N1448XMallett Robert T · Wilmington, MABuilt 1975 · S/N 28-7505229 N1449EChase Matthew S · Rock Hill, SCBuilt 1978 · S/N 17271005 N1449FJanes Brenda · Shepherdsville, KYBuilt 1966 · S/N 17254944 N1449GFayettenam Aero LLC · Laurinburg, NCS/N TC-248 N1449UInternational Aviation Group LLC · Lake Wales, FLBuilt 1976 · S/N 17267116 N1449VLogsdon Timothy D · Livermore, CABuilt 1974 · S/N 17263586 N144AAllen Engineering · San Bernardino, CABuilt 1974 · S/N D-9633 N144AMStardust Aviation LLC · Farmingdale, NYBuilt 2021 · S/N 28020016 N144ASValiair Lc Trustee · Casper, WYBuilt 1973 · S/N 31-7300903 N144BFHyldburg Aviation Inc · Plymouth, MABuilt 1974 · S/N 17264101 N144CNGalliot Bond LLC · Atlanta, GAS/N 27-8054036 N144CTCti Aircraft Leasing LLC · Memphis, TNS/N 2881298 N144DRandall John R · Pearl River, LABuilt 1978 · S/N 18053001 N144EZFlorida Aviation LLC · Tallahassee, FLS/N 32R-7885184 N144FFoster Gary E · Kress, TXBuilt 1963 · S/N D-7142 N144GMWilliams David · Golden, MOBuilt 1962 · S/N D-7010 N144JHTrachtenberg Dennis J · San Diego, CAS/N 31059 N144JKLong Island Aviators LLC · Seaford, NYBuilt 1981 · S/N 34-8133010 N144KPrescott Medical Relief Services LLC · Prescott, AZBuilt 1977 · S/N E-947 N144KFHostetler Kevin J · Green Forest, ARS/N 24-1698-14 N144LHPaul John R · Hamilton, MTS/N RLH14 N144LMHobert Robert W Trustee · Penn Valley, CABuilt 1957 · S/N D-5267 N144MC450 Dancer LLC · Benton Harbor, MIBuilt 1967 · S/N 28-22804 N144PTHill Howard H Trustee · Portage, WIBuilt 1990 · S/N E-2553 N144PWAerowood Aviation LLC · Monroe, NCBuilt 1965 · S/N 17254019 N144RExtrivo Inc · Lewes, DEBuilt 1967 · S/N D-8496 N144RCKilgore Shawn K · Argyle, TXBuilt 1974 · S/N TC-1750 N144RUG&M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 44-7995323 N144SBPeters Aircraft Sales Flp · Wshngtn Ct Hs, OHBuilt 1979 · S/N CE-862 N144TDDahlberg Thomas K · Belvidere, ILBuilt 1999 · S/N E-3289 N144TLNielson Mark Allen · Willmar, MNBuilt 1959 · S/N 24-1205 N144WPDresel Av LLC · Fayetteville, ARBuilt 1973 · S/N 21059900 N1450BBerry Boger Yacht Sales Inc · North Myrtle Beach, SCBuilt 1977 · S/N E-989

Back to AD 98-21-21 R1