Registered aircraft · 2,131

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:2009-13-06-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:2009-13-06-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:2009-13-06-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:2009-13-06-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:2009-13-06-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:2009-13-06-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.

N444CYShuman Farms Inc · Reidsville, GABuilt 1984 · S/N 42-5501025 N444JKHodges Aviation LLC · Cleburne, TXBuilt 1977 · S/N 27-7854025 N444PCValiair Limited Company Trustee · Casper, WYBuilt 1979 · S/N 31T-7920066 N444RCTiffin Aire Inc · Tiffin, OHBuilt 1975 · S/N 31T-7520030 N444VMPrecise Flights LLC · Jensen Beach, FLBuilt 1974 · S/N 27-7405320 N444WGSchmucker Real Estate Holdings Lp · Wilmington, DEBuilt 1981 · S/N 31T-8166054 N4451PUpper Apache LLC · Titusville, FLS/N 23-1968 N4452PAviation Business Corporation · Saint Louis, MOBuilt 1961 · S/N 23-1969 N4457PSkyhaven Airport Inc · Tunkhannock, PABuilt 1961 · S/N 23-1974 N445FMAgee Mark L · Greenacres, WAS/N 31-7612046 N4462PHighlands Aero Flight Center LLC · Abingdon, VABuilt 1962 · S/N 23-1983 N4473PSemeniuk Steven T · Houston, TXS/N 23-2018 N4475PRamaswamy Gautam · Clearwater, FLBuilt 1961 · S/N 23-1997 N447TThompson Systems Inc · Amana, IABuilt 1969 · S/N 27-4288 N4487PAccelerated Aviation Instruction LLC · Owatonna, MNBuilt 1962 · S/N 23-2009 N448CASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 425527034 N4490PWelke Aviation Inc · St James, MIBuilt 1962 · S/N 23-2012 N4494FBella'S Business LLC · Kalispell, MTBuilt 1959 · S/N 23-1815 N4494PSimon Mitchell B · Edison, NJBuilt 1961 · S/N 23-2016 N4496PPerez Amaro Angel L · Arecibo, PRBuilt 1960 · S/N 232011 N4497PMatthews Aviation LLC · Hardinsburg, KYBuilt 1961 · S/N 23-2020 N4499PTls Aviation · Marysville, WABuilt 1961 · S/N 23-2022 N449TAValiair Limited Company Trustee · Casper, WYS/N 31-480 N44ACFox Aircraft LLC · Bethel, AKBuilt 1980 · S/N 31-8052147 N44FDHildreth David M · Kennesaw, GABuilt 1956 · S/N 23-500 N44GRFlying High LLC · Plainfield, ILBuilt 1976 · S/N 31-7652074 N44PTDaedalus Flight Service Inc · P FokaiaBuilt 1972 · S/N 27-4793 N45002New England Aviation Air Charters LLC · Plainville, CTBuilt 1980 · S/N 31-8052161 N45014Marc Inc · Bolton, MSBuilt 1980 · S/N 31-8052171 N4501B70 North LLC · Anchorage, AKBuilt 1980 · S/N 31-8052168 N45050Rav Aviation LLC · Miramar, FLBuilt 1969 · S/N 27-4271 N45052Talkeetna Aero Services Inc · Anchorage, AKBuilt 1980 · S/N 31-8152063 N450ASConroy Philip L · Colleyville, TXBuilt 1978 · S/N 27-7854123 N450KCCharles City Aeronautics Inc · Charles City, IABuilt 1978 · S/N 31-7852092 N450MWValiair Ltd Co Trustee · Casper, WYS/N 42-5527013 N4515PFlying W Leasing Inc · Bartlett, ILBuilt 1960 · S/N 27-18 N4525PFlying L Aircraft Inc · Fort Denaud, FLBuilt 1960 · S/N 27-29 N4528PCartagena Carlos A · Sierra Vista, AZBuilt 1960 · S/N 27-32 N4529PAeroclub Management LLC · Cincinnati, OHBuilt 1960 · S/N 27-33 N4531PDelta Sierra LLC · Naples, FLS/N 27-35 N453CBDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-2573 N454CACul8tr LLC · Boynton Beach, FLBuilt 1982 · S/N 31T-8104053 N4552PCape Fear Aviation Maintenance LLC · Fayetteville, NCS/N 27-58 N4558PAviation Services Of Tn Inc · Dover, DEBuilt 1960 · S/N 27-64 N455MMMiklus Enterprises LLC · Middletown, DEBuilt 1980 · S/N 31T-8020087 N4560PAmerican Trans Air Training Corp · Virginia Beach, VABuilt 1960 · S/N 27-66 N456DALiberty Air LLC · Christiansted, VIBuilt 1979 · S/N 31-7912103 N4575PWings Management Co LLC · Rio Rancho, NMBuilt 1960 · S/N 27-84 N4597PGv Air Inc · Medford, ORBuilt 1960 · S/N 27-107 N45MJFollowell Robert L · Germantown, TNS/N 31-7912104

Back to AD 2009-13-06 R1