OpenAirDocs.org
AD 98-21-21 R1

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
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.

N205CLFreedenberg Philip J · Canton, CTBuilt 1963 · S/N 205-0452N205CRRlh Montana LLC · Helena, MTBuilt 1963 · S/N 205-0286N205CSFillwock Bryan T · Saint Joseph, MIBuilt 1977 · S/N 24-0223N205CTBas Part Sales LLC · Greeley, COS/N 205-0226N205DAero America Holdings LLC · Indianola, IAS/N 24-3005N205DCPocohantas Holdings LLC · Annapolis, MDBuilt 1986 · S/N 24-3004N205FBennett James G · Erie, COBuilt 1964 · S/N 205-0573N205FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020205N205FJPilots Nw Inc · Bellingham, WABuilt 1962 · S/N 205-0050N205GIntegrity Aero LLC · Boerne, TXBuilt 1987 · S/N 24-3038N205HHayes Manufacturing · Parsons, TNBuilt 1986 · S/N 24-3006N205HBMattes Michael Alan · Sherman Oaks, CABuilt 1977 · S/N 24-0288N205HNTischer Jesse · Des Moines, IABuilt 1963 · S/N 205-0440N205JBmr Aviation LLC · Wilmington, DEBuilt 1986 · S/N 24-3002N205JJUpchurch Howard L · Pikeville, TNS/N 24-3053N205JNHand Patrick · Cape Charles, VABuilt 1967 · S/N 18258437N205JSHollenberg Randall W · Houston, TXS/N 24-3001N205KDBats Aero LLC · Missoula, MTBuilt 1986 · S/N 24-3017N205KKBrignac Valmon Anthony III · Raleigh, NCBuilt 1987 · S/N 24-3054N205KTMha Interests LLC · Spring, TXBuilt 1981 · S/N TH-1286N205LSky King Airplanes LLC · Lewes, DEBuilt 1963 · S/N 205-0329N205LLStemple Jasper Forest · Kalispell, MTS/N 24-3055N205MESf Imports LLC · Bluffdale, UTBuilt 1990 · S/N 24-3161N205MGGanter Berthold H · Woodside, CABuilt 1987 · S/N 24-3025N205MHIsmail Ahmad · Richmond, VAS/N 24-3026N205MKCloudskipper Inc · Salisbury, MDBuilt 1987 · S/N 24-3029N205MNCubbage Mark J · Tucson, AZS/N 24-3019N205MPSadler Ryan T · Alameda, CABuilt 1987 · S/N 24-3032N205NHuff Thomas W · West Melbourne, FLBuilt 1987 · S/N 24-3030N205NBAirmotive Service LLC · Brigham City, UTBuilt 1962 · S/N 205-0151N205NDThompson Shane E · Warroad, MNBuilt 1966 · S/N 18051744N205NRState Of Minnesota · Grand Rapids, MNBuilt 1981 · S/N 18504317N205PLQuinones Luis I · Gaithersburg, MDBuilt 1987 · S/N 24-3020N205PMHochstetler Allen D · Fairfield, CABuilt 1964 · S/N D-7599N205PPBelai E Enterprise LLC · Burleson, TXFirst renewal noticeS/N 24-3061N205QQSundhagen Construction Inc · Saint Ignatius, MTS/N 24-3069N205RGKeating Kevin C · Asheville, NCBuilt 1988 · S/N 243078N205RJBrickey Thomas J · Loveland, OHBuilt 1979 · S/N 24-0774N205RLAlcott Thomas J · Jacksonville, ILBuilt 1987 · S/N 24-3022N205RSGansta Of Love LLC · Moorpark, CABuilt 1979 · S/N 24-0797N205RTTriple D Cessna LLC · Greenville, SCBuilt 1962 · S/N 205-0014N205RWGarratt Tyler Trustee · Carlsbad, CAS/N 24-3052N205SJudson Alexander · Hermitage, TNS/N 24-3014N205SAConner Brian J · Davenport, CAS/N EA-273N205SERecreation Activity Club Inc · Bloomfield Hills, MIS/N 24-3051N205SF242 Skies LLC · Troutman, NCBuilt 1977 · S/N 32R-7780311N205SSAir Turbo LLC · White, GAS/N 24-3060N205TGLe Garrec Jean-Dominique M · Pittsburgh, PABuilt 1987 · S/N 24-3041N205THAaces Flight Operations LLC · Ellisville, MOBuilt 1981 · S/N 28-8190282N205UGoro Sky Aircraft LLC · Lino Lakes, MNS/N 24-3036
Back to AD 98-21-21 R1