Skip to content

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.

N252ARSkousen Joel · Spring City, UTBuilt 1986 · S/N 25-1010 N252ASN252as LLC · Hillsboro, ORS/N 25-1121 N252AVKortopates Paul T · San Diego, CABuilt 1985 · S/N 25-1006 N252AYMartinkewiz Gregory · Argyle, TXBuilt 1985 · S/N 25-1004 N252AZShellhouse Robert Gregory · Dayton, OHS/N 25-1003 N252BWoods Brian S · Longview, TXBuilt 1986 · S/N 25-1012 N252BACoastal Orthopedic Associates LLC · Holmdel, NJS/N 25-1122 N252BDLachman Aaron · The Woodlands, TXBuilt 1987 · S/N 25-1126 N252BHHorst Commercial Ventures LLC · Sanger, TXBuilt 1987 · S/N 25-1137 N252BMJeffrey Friday · Carbondale, COS/N 25-1124 N252BNGibisch Glenn J · Naples, FLS/N 25-1138 N252BRMann John · Coopersburg, PAS/N 25-1141 N252BSAlta Aviation LLC · Broomfield, COBuilt 1987 · S/N 25-1107 N252BYLance Christopher D · Vacaville, CAS/N 25-1162 N252BZJml Ventures LLC · Luverne, ALS/N 25-1168 N252CAHuckabay John A · Coeur D Alene, IDS/N 25-1064 N252CCLetsgobrandon.Com LLC · Pine Bush, NYS/N 25-1132 N252CFBowman Douglas G Trustee · Santa Rosa, CAS/N 25-1129 N252CGPlane Fun Inc Tr Trustee · Snellville, GAS/N 25-1033 N252CNMcmanus Thomas M · Ridgefield, CTS/N 25-1146 N252CRMcvay Thomas T · Minneapolis, MNS/N 25-1165 N252D252 Delta Inc · Atlanta, GABuilt 1986 · S/N 25-1014 N252DBValiair Lc Trustee · Casper, WYBuilt 1989 · S/N 25-1199 N252DCEhrick Richard T · Steamboat Springs, COBuilt 1983 · S/N 25-0785 N252DKKristoferson David J · Georgetown, TXBuilt 1988 · S/N 251167 N252DLPlac Holdings LLC · Paradise, TXBuilt 1975 · S/N 310R0242 N252DPDream Flite LLC · Sarasota, FLBuilt 1973 · S/N TE-932 N252DRGoudeau Lyle A · Scottsdale, AZS/N 25-1038 N252DSSturgill Duell L · Staffordsville, KYS/N 25-1065 N252DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010033 N252EXiaowei Shi · Las Vegas, NVBuilt 1986 · S/N 25-1015 N252ECClear Sky Ag Services LLC · Arapahoe, COBuilt 1969 · S/N 28-25277 N252EMMaidens Donald S · Novi, MIBuilt 1986 · S/N 25-1027 N252ERBeaurayne Holdings LLC · Prairieville, LABuilt 1978 · S/N 17271635 N252FBKramer Vernon F · Eagle River, WIS/N 25-1131 N252FMHawk Unlimited LLC · Kalispell, MTBuilt 1986 · S/N 25-1028 N252GBrewster King Smith Jr · Gilbert, AZBuilt 1969 · S/N 28-26191 N252GBRedrockbluewater LLC · Moab, UTBuilt 1981 · S/N 25-0518 N252GSWyoming Seaplanes LLC · Alpine, WYBuilt 1976 · S/N 18265179 N252HMLeeds Stained Glass Co Inc · Leeds, ALS/N 25-1030 N252HWBeverly Robert E · Lewis Center, OHBuilt 1987 · S/N 25-1142 N252JCRc Skywagon LLC · Miami, FLBuilt 1986 · S/N 25-1008 N252JEEdlund Richard J · Lenexa, KSBuilt 1989 · S/N 25-1202 N252JHStratton William A · Denton, TXS/N 25-1035 N252JMMccallister Billy G · Virginia Beach, VABuilt 1963 · S/N 17250277 N252JPInternational Air Services Inc Trustee · Carson City, NVBuilt 1987 · S/N 25-1127 N252KCPatton Steven W · Fayetteville, ARS/N 30964 N252KMRegistered aircraftS/N 25-1032 N252LRigoulot James Paul · Fort Mill, SCBuilt 1986 · S/N 25-1019 N252MDouglass Alloys LLC · Zanesville, OHS/N 25-1151

Back to AD 98-21-21 R1