Skip to content

Registered aircraft · 20,483

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N3293YKiedinger John D · Burleson, TXS/N 18254293 N3294UWidener Christine A · Tucson, AZBuilt 1963 · S/N 18254694 N3295YReid Brian M · Boise, IDS/N 18254295 N3296SBeekman Steven J · Stephenson, MIBuilt 1964 · S/N 18255796 N3296UBierer David E · Victor, MTBuilt 1963 · S/N 18254696 N3296YBeckord Aaron P · Tacoma, WABuilt 1962 · S/N 18254296 N3297YMust Dash Rides Flying Club LLC · Raleigh, NCBuilt 1962 · S/N 18254297 N3298SHolloway Cody L · Belle Plaine, KSBuilt 1964 · S/N 18255798 N3299SS V Aeronautics LLC · Afton, WYBuilt 1964 · S/N 18255799 N3299URichardson Ronnie L Jr · East Wenatchee, WAFirst renewal noticeBuilt 1963 · S/N 18254699 N329MABarr Air Patrol LLC · Mesquite, TXBuilt 1998 · S/N 18280102 N329WPPhillips J Weston · West Jefferson, NCBuilt 2025 · S/N 18283329 N32AKHummel Karl · Brooklyn, NYBuilt 1973 · S/N 18261935 N32CHHeckler Gary C · Carefree, AZBuilt 1966 · S/N 18257332 N32CWMcdiarmid Jeffrey · Walla Walla, WABuilt 1977 · S/N 18265680 N32DBCarpenter Forrest A · Berthoud, COBuilt 1966 · S/N 18051714 N32EKTips Dan N · Plano, TXBuilt 1963 · S/N 18051264 N32FCZimin Transportation LLC · South Naknek, AKBuilt 1953 · S/N 30431 N32LPBartlett Paul H · Nebo, NCBuilt 2025 · S/N 18283331 N32LTLt Leasing LLC · Saint Petersburg, FLBuilt 2021 · S/N 18283154 N32MCCook Tracy L · Prosper, TXBuilt 1974 · S/N 21060482 N32PLDiette Paul S · Middlebury, VTBuilt 1980 · S/N 18267595 N32PXKustatan Leasing LLC · Kenai, AKBuilt 1976 · S/N U20603343 N32RLVb Glass Company Inc · Jamestown, CAS/N U20605551 N32TCarolina Blue Aviation LLC · Villanova, PABuilt 1978 · S/N 18266670 N32VACommonwealth Of Virginia · Richmond, VABuilt 1974 · S/N 182-63322 N32ZZJp Lemke Aviation LLC · Jenison, MIBuilt 1977 · S/N 18265469 N3300YRaulston Electric LLC · Bagwell, TXBuilt 1962 · S/N 18254300 N3301DJohnson Peter L · Chico, CAS/N 32099 N3301RJuliet Zulu Holdings LLC · Dover, DEBuilt 1967 · S/N 18258601 N3302YFoster James R · Mcpherson, KSBuilt 1962 · S/N 18254302 N3303YWoolery David W Jr DBA · Lathrop, MOBuilt 1962 · S/N 18254303 N3304FStephan Pamela K · Anchorage, AKBuilt 1966 · S/N 18257304 N3305RLivingston Sonja L · Redding, CABuilt 1967 · S/N 18258605 N3305YWolfe Randall S · Wasilla, AKBuilt 1962 · S/N 18254305 N3306CSkylane Inc · Schaumburg, ILBuilt 1978 · S/N R18200269 N3306DAlquist Kevin B · Edwardsville, KSBuilt 1955 · S/N 32104 N3306UMartin Paul R Jr · Greensboro, GABuilt 1963 · S/N 18254706 N3306YSaunders Craig · Spring Hill, FLBuilt 1962 · S/N 18254306 N3307RPhan Tam M · Charlotte, NCBuilt 1967 · S/N 18258607 N3307UPatronyk Gregory M · Santa Barbara, CABuilt 1963 · S/N 18254707 N3308FBravo Hotel LLC · Lewes, DES/N 18257308 N3308RLocatelli Gabriel G · North Bend, ORBuilt 1967 · S/N 18258608 N3309CScott Parker H · Bulverde, TXBuilt 1978 · S/N R18200270 N3309SCessna 210 N3309s LLC · Yellville, ARBuilt 1969 · S/N 21059109 N3309YRuschak Donald A · Charleroi, PABuilt 1962 · S/N 18254309 N330BDD & J Holdings LLC · Ellis, IDBuilt 1973 · S/N 18261634 N330FSkydive Wayland LLC · Melbourne, FLBuilt 1957 · S/N 34329 N330GBBrenner Gary L · Mission Viejo, CABuilt 1975 · S/N 18264242 N330JDGreen Erik M · Mastic Beach, NYBuilt 1998 · S/N 18280267

Back to AD 84-10-01 R1