Skip to content

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.

N1504VCulman William A · Scotts Valley, CABuilt 1974 · S/N 17263633 N1504XVerge Aeronautics LLC · Charlotte, NCBuilt 1975 · S/N 28R-7535301 N15050Houston William W · Baltimore, MDBuilt 1972 · S/N 28-7225569 N15051Phoenix Proaviation LLC · Jacksonville, FLS/N 28-7225570 N15057Bad Dog Aviation · Meridianville, ALBuilt 1972 · S/N 28-7225572 N1505SBluboco LLC · Northville, MIBuilt 1962 · S/N D-7037 N1505TN1505t LLC · Tucson, AZBuilt 1966 · S/N P206-0212 N1505XFarrell Donald A · Owasso, OKBuilt 1975 · S/N 28R-7535302 N1505ZKc Air LLC · Wellford, SCBuilt 1962 · S/N CD-542 N15064Kropp Christian Owner Trustee · Azle, TXS/N 34-7350005 N15066Cherokee Aviation Group LLC · Alpharetta, GABuilt 1972 · S/N 28-7225577 N1506HRegistration Pending · Cape Canaveral, FLRegistration pendingS/N 28-7725147 N1506MBonn Steven · Hummelstown, PABuilt 1975 · S/N 18264356 N1506TWaldrep Zoey V · Tampa, FLS/N 28-7225538 N1506VDeshon Loren · Friday Harbor, WABuilt 1974 · S/N 17263634 N1506YVaughn Jeffery Page · Shenandoah, VAS/N 17249206 N1506ZTopspeed Black LLC · Alpharetta, GABuilt 1961 · S/N CD-395 N15079Rea Robert III · Bumpass, VABuilt 1972 · S/N 28-7225585 N1507EGonzalez Moya Camilo Rafael · Fort Worth, TXBuilt 1978 · S/N 17271028 N1507SArteta David A · Wake Forest, NCFirst renewal noticeBuilt 1962 · S/N D-6935 N1507TAero Care Inc · Orange, MABuilt 1972 · S/N 28-7205310 N15089Tusla Technology Center School District #18 · Tulsa, OKS/N 34-7350018 N1508CHutchings Alan J · Clewiston, FLBuilt 1953 · S/N 30208 N1508FHaley Wayne C · Okeechobee, FLBuilt 1964 · S/N 1850816 N1508JLiwag Reynaldo T Jr · Niagara Falls, NYBuilt 1967 · S/N 28-23901 N1508TWalker Jereme · Durham, NCBuilt 1972 · S/N 28R-7235308 N1509CHammerquist Blake T · Benicia, CABuilt 1954 · S/N 30882 N1509MChalk 2 Inc · Apple Valley, CABuilt 1975 · S/N 18264357 N1509ZHeinrich John W · Chandler, AZBuilt 1961 · S/N TC-210 N150BGMbw Aviation LLC · Bay City, MIS/N 310R-0635 N150BJDakota Air LLC · Delray Beach, FLBuilt 1983 · S/N 28-8311013 N150DRVan Den Heuvel Michael E · Middleton, WIBuilt 1990 · S/N CE-1473 N150FSCustom Air International LLC · Homestead, FLBuilt 1975 · S/N 17265554 N150LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842193 N150PNational Test Pilot School · Mojave, CABuilt 2012 · S/N 18282357 N150PFParagon Flight Training Co · Fort Myers, FLBuilt 2022 · S/N 4496545 N150PKInternational Air Services Inc Trustee · Carson City, NVS/N 287725108 N150SCAnderson Thomas R · Seattle, WABuilt 1973 · S/N U20601958 N150UUKoshar Steven R · Coloma, MIBuilt 1961 · S/N D-6630 N150WRWhiskey Romeo LLC · Timnath, COBuilt 1969 · S/N D-8911 N15100Brothers Aviation Va LLC · Manassas, VABuilt 1972 · S/N 28-7225588 N15101Blackwater Air LLC · Pace, FLBuilt 1972 · S/N 28-7305020 N15104Mil2atp Inc · Pikeville, NCBuilt 1972 · S/N 28-7225590 N15105Sass Phillip A · Leavenworth, KSBuilt 1972 · S/N 28-7225591 N15106Chew Terrence G · Allyn, WABuilt 1972 · S/N 28-7305021 N15107Skahen Sean M · Saint Joseph, MNS/N 28-7305022 N1510SClark Lahn F · Pasco, WABuilt 1962 · S/N D-6940 N1510XSedlacek John · Pittstown, NJBuilt 1975 · S/N 28R-7535307 N1510YEegle Corps Inc · Wilmington, DEBuilt 1962 · S/N 17249210 N1511Plane Fun LLC · Warrensburg, MOS/N 28R-31114

Back to AD 98-21-21 R1