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.

N21323A2t Guys Aviation LLC · Williamston, MIBuilt 1978 · S/N 28-7916033 N21328Endler Harold A · Black Mountain, NCBuilt 1972 · S/N 18261563 N21329Propeller Enterprises LLC · Gilbert, AZBuilt 1974 · S/N 17263931 N2132FHitchcock Wayne · Shelbyville, TNBuilt 1964 · S/N U206-0332 N2132JHolley William M · Rock Port, MOBuilt 1978 · S/N 28-7990216 N2132LCsrh Ventures LLC · Lubbock, TXBuilt 1976 · S/N D-9923 N2132RSifsof Victor G DBA · Anchorage, AKBuilt 1964 · S/N 18255332 N2132TMatejcek Lina M · Owatonna, MNBuilt 1971 · S/N 28-7125448 N21332Celmer Charles A · Puyallup, WABuilt 1972 · S/N 18261566 N21333Melius Ray D · Erda, UTBuilt 1972 · S/N 18261567 N21338N21338 LLC · Amarillo, TXBuilt 1972 · S/N 18261571 N2133ASchnack Kenneth L · Crescent, IAS/N 32R-7987007 N2133GPrice Bradley E · Sacramento, CAS/N 51433 N2133JHoosier Aviation LLC · Terre Haute, INBuilt 1978 · S/N 28-7990217 N2133RLewis Christopher S · Hancock, MIBuilt 1964 · S/N 18255333 N2133WBeck Robert M · Bakersfield, CABuilt 1974 · S/N CE-502 N2133YBullock John E Jr · Birdseye, INBuilt 1962 · S/N 17249633 N21343Bulger Thomas R · Oak Harbor, WABuilt 1972 · S/N 18261575 N21344Skylane Therapy LLC · Nampa, IDBuilt 1972 · S/N 18261576 N21347Kessler Frank J Jr · Gallatin, TNBuilt 1974 · S/N 17263933 N21348Nri Flying Club Inc · Walnut Creek, CABuilt 1972 · S/N 18261578 N2134DRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1978 · S/N 28-7916144 N2134ERice Larry Anthony Trustee · Yucaipa, CABuilt 1978 · S/N 28-7990180 N2134JMcmahan Michael Anthony · Dunwoody, GABuilt 1978 · S/N 28-7990218 N2134LHeyen John M · Springfield, ILBuilt 1976 · S/N E-890 N2134NPainter Christopher R · Castle Rock, COBuilt 1979 · S/N 28R-7931048 N2134RVanek Peter · Sedona, AZBuilt 1969 · S/N 28-5467 N2134SC Squared Inc · Stevensville, MDBuilt 1979 · S/N R18201307 N2134TBartow Municipal Airport Development Authority · Bartow, FLBuilt 1971 · S/N 28R7135142 N2134UDean Steel Buildings Inc · Fort Myers, FLBuilt 1982 · S/N 21064775 N2134YHi Line Flying Club Inc · Seattle, WABuilt 1962 · S/N 17249634 N2134ZAvex Holdings Heli Inc · Lewes, DEBuilt 1963 · S/N 18051234 N21351Midwest Flying Service LLC · Wilmington, DEBuilt 1974 · S/N 17263934 N21352Lane Shannon L · Hopkinsville, KYBuilt 1978 · S/N 32R-7885252 N21353Elm Aviation LLC · Norfolk, VABuilt 1998 · S/N 25-2032 N21356Elite Financial Management Inc · Dallas, TXBuilt 1978 · S/N 32R-7887202 N21357Wild Outdoors Oil LLC · Velma, OKBuilt 1978 · S/N 32R-7887203 N21358Paroulek Joseph F · Milton, DEBuilt 1972 · S/N 18261585 N2135BMiloud Chadd K · Fort Worth, TXBuilt 1978 · S/N 28-7916110 N2135FMark Alan Bennett · Trinidad, COS/N 28-7990188 N2135TPeter Prince Aviation Center LLC · Milton, FLBuilt 1971 · S/N 28R-7135139 N2135WLeary Kevin · Midland, TXBuilt 1974 · S/N D-9648 N2135ZCapps Boyce Daniel · Newcastle, OKBuilt 1963 · S/N 18051235 N21360Weede Roger H · Dubois, WYS/N 17263935 N21362Joyce James R · Bellevue, WABuilt 1972 · S/N 18261587 N21368Alta Air LLC · Boise, IDBuilt 1972 · S/N 18261589 N2136CPope Keith D · Mineral Wells, TXBuilt 1978 · S/N 28-7911022 N2136DLeake Richard · Fresno, CABuilt 1953 · S/N D-3481 N2136EInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 28R-7918002 N2136GCulver Deborah M · Anchorage, AKBuilt 1958 · S/N 51436

Back to AD 98-21-21 R1