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.

N172JDBlack Hound Aviation LLC · Austin, TXBuilt 1974 · S/N 17263844 N172JGGroendyke Jerry G · Fort Pierce, FLBuilt 1969 · S/N 17257987 N172JHHaugen Jim · Maiden Rock, WIBuilt 1962 · S/N 17248803 N172JJFort Leavenworth Flying Activity · Fort Leavenworth, KSBuilt 1975 · S/N 17265488 N172JKHillman Aviation LLC · Bossier City, LABuilt 1964 · S/N 17251337 N172JLSutton Aircraft Salvage LLC · Palmer, AKS/N 17257724 N172JMCardinal Wings Aviation LLC · Buckner, KYS/N 17262202 N172JTLiberty Zone LLC · Wilmington, DEBuilt 1964 · S/N 17251132 N172KCWellner Thomas B · Bremerton, WABuilt 1965 · S/N 17252649 N172KDKad Aviation LLC · Athens, ALBuilt 1976 · S/N 17267467 N172KGSimons Laura · London, KYS/N 17270311 N172KJJa Flight Services LLC · Sugar Cove, ILS/N 17268124 N172KPBitzan Joseph D · Charlotte, NCBuilt 1968 · S/N 17257218 N172KRRose Kim M · Mount Vernon, OHBuilt 1965 · S/N 17252960 N172KWTap Solutions Inc · San Diego, CABuilt 1979 · S/N 17272254 N172KYAir Dogs LLC · Mount Washington, KYBuilt 1975 · S/N 17266093 N172LCIfly Aviation LLC · Conway, ARBuilt 1974 · S/N 17263219 N172LFSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1979 · S/N 17273380 N172LGPolk Brandon A · Valrico, FLBuilt 1974 · S/N 17264203 N172LJN W Aviators Inc · Troutdale, ORBuilt 1975 · S/N 17266242 N172LRDevillers Daniel R · Kalamazoo, MIBuilt 1960 · S/N 47607 N172LWCrane Donald L · Kenai, AKBuilt 1967 · S/N 17255790 N172MC172 Mikecharlie LLC · Ocala, FLBuilt 1975 · S/N 17265980 N172MDDc Aerial Photos Inc · Fredericksburg, VABuilt 1974 · S/N 17263421 N172MEBlue Ridge Airworks LLC · Charlottesville, VABuilt 1974 · S/N 17263996 N172MFRhody Skyhawk Flying Club LLC · Middletown, DES/N 17258001 N172MHHoward Michael G · Slaughters, KYBuilt 1978 · S/N 17271660 N172MKRivera Glauco A · Isabela, PRBuilt 1976 · S/N 17266714 N172MLHampton Flying Services LLC · Portsmouth, NHBuilt 1973 · S/N 17261580 N172MPPasswater Michael E · Upland, CABuilt 1961 · S/N 17248976 N172MRGorge Winds Aviation Inc · Fairview, ORBuilt 1976 · S/N 17267684 N172MSAirgo Inc · Centralia, ILFirst renewal noticeBuilt 1974 · S/N 17263928 N172MXDmac Aircraft LLC · Savannah, GAS/N 17269939 N172NEast Tennessee Pilots Club · Knoxville, TNBuilt 1978 · S/N 17270403 N172NCChase James W · Port Orange, FLS/N 17260468 N172NDBlue Max Aero LLC · Miles City, MTBuilt 1988 · S/N 2837007 N172NPDv Aviation Inc · Brainerd, MNBuilt 1978 · S/N 17270971 N172NSWings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17257968 N172NXHolcomb Garry M · Point, TXBuilt 1960 · S/N 17248148 N172PARoseville Aviation LLC · Roxboro, NCS/N 17269467 N172PFMillard Richard A · Waverly, TNBuilt 1969 · S/N 17258891 N172PGAviation Career Enrichment Inc · Atlanta, GABuilt 1975 · S/N 17265821 N172PHRegistration Pending · Milton, DERegistration pendingBuilt 1963 · S/N 17250918 N172PJSlykhouse Gary B · Grand Rapids, MIBuilt 1966 · S/N 17255099 N172PKKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1979 · S/N 17273616 N172PM98x LLC · Caddo Mills, TXS/N 17256117 N172PRPark Rapids Aviation Inc · Park Rapids, MNBuilt 1974 · S/N 17264084 N172PSSchwarzenberg Johannes · MoosburgBuilt 1967 · S/N 172-55822 N172PTSpanaflight LLC · Puyallup, WAS/N 17270734 N172PWDynamics Flight LLC · Milwaukee, WIS/N 17270432

Back to AD 98-21-21 R1