Skip to content

Registered aircraft · 47,138

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:2000-23-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21') 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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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:2000-23-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
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.

N2863YPiontek Claudia A · Henderson, NVBuilt 1962 · S/N 18253863 N2864FPreszler Sharon J · Mesa, AZBuilt 1966 · S/N 18256964 N2865BBui Gregory M · Tigard, ORBuilt 2018 · S/N 1795 N2865FMctaggart Briar · Oroville, CAS/N 18256965 N2865YSinclair Maurice A · Melrose, IAFirst renewal noticeBuilt 1962 · S/N 18253865 N2866ATruman Sparks Aviation LLC · Snyder, TXBuilt 1953 · S/N 30066 N2866FHowell Thomas F · Red Bluff, CAS/N 18256966 N2866KDobransky Robert J · Peoria, AZBuilt 1979 · S/N 18053104 N2867YCook Kevin M · Hallettsville, TXBuilt 1962 · S/N 18253867 N2868ATaylor Eric C · Port Townsend, WABuilt 1953 · S/N 30068 N2868FBrown Isabelle R · Bay Shore, NYBuilt 1966 · S/N 18256968 N2868KMyers Mark D · Anchorage, AKBuilt 1979 · S/N 18053105 N2869RDiehl Steven L · Martinsburg, PABuilt 1967 · S/N 18258469 N2869UDavis Isabelle L · Mason, NHBuilt 1971 · S/N 18052216 N2869YDurand Russell Gene · Luthersville, GABuilt 1962 · S/N 18253869 N286AKDog Island Air Inc · Wilmington, DEBuilt 2002 · S/N 0303 N286BBBell Family Cirrus LLC · Louisville, KYBuilt 2022 · S/N 8919 N286BWCalifornia Falcon Aviation Inc · Anaheim, CABuilt 1979 · S/N 34-7970182 N286CMB&K Aircraft Leasing LLC · West Plains, MOBuilt 1986 · S/N 46-8608043 N286DAAmitin Daniel · Los Angeles, CABuilt 2023 · S/N 9488 N286FDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 9930 N286LDSpectre Aviation Group LLC · Johnson City, TNBuilt 2022 · S/N 8916 N286MWGeneral Purpose Vehicle LLC · San Francisco, CABuilt 2022 · S/N 8678 N286TCJb Aviation LLC · Waxahachie, TXBuilt 1986 · S/N 21065001 N286WSchlutz Greg F · Longmont, COBuilt 1966 · S/N D-8042 N286XKelly John Thomas III · Bells, TXBuilt 1975 · S/N 6113C N2870ARodriguez Rafael Corrales · Miami, FLBuilt 1979 · S/N 28R-7931232 N2870WRobinson John D · Peachtree City, GABuilt 1973 · S/N D-9501 N2870YDabevv LLC · Salina, UTBuilt 1962 · S/N 18253870 N2871CTaylor Brandon C · Prosper, TXBuilt 1979 · S/N 28-7921079 N2871KPace Robert A Jr · Pensacola, FLBuilt 1979 · S/N 18053107 N2871RBlue Ridge Flyers Inc · Leesburg, VABuilt 1967 · S/N 18258471 N2871WBuess Wayne R · Shirley, NYBuilt 1974 · S/N TH-462 N2871YJohnson Cynthia Trustee · Sagle, IDS/N 18253871 N2872AArdmore Aviation LLC · Russell Twp, OHBuilt 1953 · S/N 30072 N2872KR N Geraci LLC · Lutz, FLBuilt 1979 · S/N 18053108 N2872THenley Brett · Manchester, TNBuilt 1979 · S/N 34-7970316 N2873AAndelin Sheila P · Newport Beach, CABuilt 1953 · S/N 30073 N2873WHolland Edgar S · Fletcher, NCBuilt 1973 · S/N TC-1580 N2873YMorris Ben M · Albany, GABuilt 1962 · S/N 18253873 N2874KWashburn Kent F · Grants Pass, ORBuilt 1979 · S/N 18053110 N2875WTreadway Ag Delaware LLC · Lewes, DES/N D-9508 N2876FJohnston Natalie R · Edgewood, TXBuilt 1966 · S/N 18256976 N2876YForbes Richard L · Plano, TXBuilt 1962 · S/N 18253876 N2877ADutremble Donald L · Amherst, NHBuilt 1953 · S/N 30077 N2877YBrumback Recreation LLC · Bluffdale, UTBuilt 1962 · S/N 18253877 N2878AAero Garage Inc · Fort Myers, FLS/N 30078 N2878MCamous Alain E · Sunrise, FLBuilt 1977 · S/N 28R-7803152 N2879CAero Jackson LLC · Bradenton, FLBuilt 1979 · S/N 28R-7931237 N2879FMinich Sophie R · Anchorage, AKS/N 18256979

Back to AD 2000-23-21