Registered aircraft · 85,612

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.

N2722CHavener Walter J · Lodge Grass, MTBuilt 1954 · S/N 26266 N2722DFly South Aviation LLC · Little Rock, ARS/N 26889 N2722GEpperson David C · Salt Lake City, UTFirst renewal noticeBuilt 1959 · S/N 52022 N2722LSmolik Amanda · Northlake, TXBuilt 1967 · S/N 17255922 N2722RPerez Angel L · Arecibo, PRBuilt 1969 · S/N 28R-35268 N2722XRearden Michael B · Homer, AKBuilt 1965 · S/N 18051522 N2723BPiston Aviation LLC · Saint Charles, MOBuilt 1969 · S/N 28-25852 N2723DBarnes Jeffrey L · Odessa, TXBuilt 1952 · S/N 25265 N2723EMarshals Technology LLC · Martinez, GABuilt 1978 · S/N 17271306 N2723FTrantham Robert Keith · Alexandria, ALBuilt 1966 · S/N 18256823 N2723GReno Timothy J · University Place, WABuilt 1959 · S/N 52023 N2723LJkr7 LLC · The Dalles, ORBuilt 1967 · S/N 17255923 N2723WSenneff James L · Clarence, NYBuilt 1966 · S/N 3337 N2724CN2724c LLC · Levering, MIBuilt 1954 · S/N 26268 N2724DRojas Conrad · Fairbanks, AKBuilt 1952 · S/N 25266 N2724FIsley Rocky · Lacey, WABuilt 1965 · S/N 18256824 N2724JHorseshoe Air LLC · Pella, IAS/N 185-1474 N2724TWittenbrader Jeff · Lake Ariel, PABuilt 1967 · S/N TE-354 N2724UGarner Harry W · Le Roy, NYBuilt 1963 · S/N 17250324 N2724WHebert David D · Mcalester, OKBuilt 1966 · S/N 3338 N2724XParrott Charles F · Bridgton, MEBuilt 1965 · S/N 18051524 N2725F85 Charlie Papa LLC · Phoenix, AZBuilt 1965 · S/N 18256825 N2725LFulenchek Raymond D · Sherman, TXS/N 17255925 N2725WMorris Curtis D · Magnolia, TXS/N 1029 N2726DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 25268 N2726GFarmhouse Aerospace LLC · Laurel, MTBuilt 1959 · S/N 52026 N2726USampan Aviation LLC · Greenville, TXS/N 17250326 N2726YOlson Ben A · Gig Harbor, WABuilt 1957 · S/N TD-76 N27272Alpha United Air LLC · Wilmington, DEBuilt 1977 · S/N 31-7712063 N2727CWennersten Donald A · Ann Arbor, MIBuilt 1954 · S/N 26271 N2727DMcfarlane Scott J · Denair, CABuilt 1952 · S/N 25269 N2727MFly-N-Style LLC · South Lyon, MIBuilt 1977 · S/N 28-7816303 N2727QEstes Gregory T · Jonesville, VABuilt 1967 · S/N 18257927 N2727URoy Justin C · Georgetown, OHBuilt 1963 · S/N 17250327 N2727YFreedom Aviation LLC · Dover, DEBuilt 1958 · S/N TD-79 N27282Sanborn Map Company Inc · Colorado Springs, COBuilt 1977 · S/N 31-7712071 N2728BBig Island Gravity LLC · Kapaau, HIBuilt 1959 · S/N 52028 N2728CMeidl Jared · Crivitz, WIS/N 26272 N2728DOsteo Naturals LLC · Belchertown, MABuilt 1994 · S/N 2811039 N2728LPotter Mark H · Santa Rosa, CABuilt 1967 · S/N 17255928 N2728QDanmick Holdings LLC · Dickson, TNFirst renewal noticeBuilt 1977 · S/N 28-7790416 N2728TMilk Ranch LLC · Stephenville, TXBuilt 1967 · S/N D-8447 N2728UCatsakis Andrew W · Lovettsville, VABuilt 1963 · S/N 17250328 N2728WNash Richard D · Edgewood, WABuilt 1966 · S/N 3339 N2728XUsda Forest Service Fepp · Trenton, NJBuilt 1965 · S/N 18051528 N27299C M B Aviation LLC · Farmington Hills, MIBuilt 1977 · S/N 31-7752128 N2729FSexton & Sanders Law Firm Pa · Fort Smith, ARBuilt 1965 · S/N 18256829 N2729QCraft Phyllis C · Damascus, GABuilt 1967 · S/N 18257929 N2729TWasileski David J · Auburn, NYS/N D-8451 N2729UDenair Inc · Canandaigua, NYBuilt 1963 · S/N 17250329

Back to AD 98-21-21 R1