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.

N2423EGood Flight Aviation LLC · Stockton, CABuilt 1978 · S/N 17271276 N2423FSwalling Paul C · Anchorage, AKBuilt 1965 · S/N 18051623 N2423LBig Hook Wilderness Camps LLC · Snowmass Village, COBuilt 1966 · S/N 17255623 N2423RAluminum Falcons Flying Club LLC · Bloomsburg, PABuilt 1969 · S/N 28-5619 N2423SAircraft Sales LLC · Caledonia, MIBuilt 1976 · S/N 21061275 N2423UChord Line LLC · Homer, AKBuilt 1963 · S/N 17250023 N2423XCarrier Peter · Skowhegan, MEBuilt 1965 · S/N 18256323 N2423YStevens Mark E · Virgilina, VABuilt 1962 · S/N 17249723 N2424FPerformance Aviation Services LLC · Belmont, OHBuilt 1964 · S/N 28-2117 N2424LRoberts Steven R · Palo Verde, AZBuilt 1966 · S/N 17255624 N2424Q24q Inc · Cedar City, UTBuilt 1966 · S/N 18257624 N2424RCurlee Derek · Yoakum, TXBuilt 1964 · S/N 18255524 N2424VLuvsflying Flight Training LLC · Staten Island, NYBuilt 1972 · S/N 28-7225586 N2424YBeek Nigel A · Pembroke Pines, FLBuilt 1962 · S/N 17249724 N2425AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496252 N2425CGiovanini Terry L · Bozeman, MTBuilt 1979 · S/N 18267471 N2425GMccune Charles · Metamora, ILBuilt 1959 · S/N 51725 N2425LZappia Jonathan L · Yucaipa, CABuilt 1967 · S/N 17255625 N2425MTap Solutions Inc · San Diego, CABuilt 1977 · S/N 28-7816283 N2425RDietze Weldon W · Seguin, TXBuilt 1964 · S/N 18255525 N2425SPark Sung S · Marana, AZBuilt 1976 · S/N 21061276 N2426DPalmer Bryon · Fall City, WABuilt 1952 · S/N 20578 N2426L588 Delta LLC · Seminole, OKBuilt 1966 · S/N 17255626 N2426RRiley Aerospace LLC · Sebastian, FLBuilt 1964 · S/N 18255526 N2426UMartin Odis Bruce · Whitney, TXBuilt 1963 · S/N 17250026 N2426XColwell Patrick R Jr · Medford, WIBuilt 1965 · S/N 18256326 N2426YShamrock Flying Club Inc · Millersville, PABuilt 1962 · S/N 17249726 N2427GMcneil Jesse M · Central, AKBuilt 1959 · S/N 51727 N2427LT&T Aviators LLC · Buford, GAS/N 17255627 N2427M18 Rwy LLC · Falmouth, MEBuilt 1977 · S/N 28-7816284 N2427RFalcon Flight Squadron Inc · Los Angeles, CABuilt 1969 · S/N 28-5620 N2427UGalante Anthony R · Saint Clair, MIBuilt 1979 · S/N 28-8090044 N2427YGreen Terry W · Binger, OKFirst renewal noticeS/N 17249727 N2428CRegistered aircraftBuilt 1954 · S/N 30728 N2428GBackcountry Guys LLC · Prescott, AZBuilt 1959 · S/N 51728 N2428PHill Tim E · Russellville, ARBuilt 1970 · S/N 39-64 N2428RAltimeter Inc · San Marcos, TXBuilt 1964 · S/N 18255528 N2428XBiggs Clifford G · Washington, UTBuilt 1965 · S/N 18256328 N2428YYellen Mark A · Mohave Valley, AZBuilt 1962 · S/N 17249728 N2429EByrd David Phillip · King Salmon, AKBuilt 1966 · S/N 185-1172 N2429GSkydive Florida Keys Inc · Summerland Key, FLS/N 51729 N2429LCook Shawn R · Middlebury, VTBuilt 1966 · S/N 17255629 N2429TKlassen William Peter · Davis, CABuilt 1976 · S/N 28-7690390 N2429UNorman Jon Frederic Jr · Pineville, LABuilt 1963 · S/N 17250029 N2429XMontpetit Steven W · New Richmond, WIBuilt 1965 · S/N 18256329 N2429YTucker Robert A · Kingston, OHBuilt 1962 · S/N 17249729 N242AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881732 N242AVN242av LLC · Manassas, VABuilt 1972 · S/N 17260470 N242BBN242bb Inc · Fort Lauderdale, FLBuilt 1980 · S/N 25-0485 N242CBHarte Mike · Lone Star, TXBuilt 1978 · S/N 24-0459

Back to AD 98-21-21 R1