Registered aircraft · 13,306

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

N221SFHickam Air LLC · Plainview, NYBuilt 2021 · S/N 2266 N221TBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1985 · S/N 46-8508061 N221TTCirrus Design Corp · Duluth, MNBuilt 2021 · S/N 2248 N221TXSooner Aviation LLC · Helena, MTBuilt 2007 · S/N 2468 N221VArea 52 Holdings Inc · Darlington, SCBuilt 2003 · S/N 29-0295 N221VCSix Shooter Aircraft LLC · Alto, NMBuilt 2024 · S/N 9989 N221VLLumen Air Holdings LLC · Clayton, MOBuilt 2026 · S/N 11405 N221WBOtter Rock Aero LLC · Newport, ORBuilt 2005 · S/N 41091 N2220NDushek Matthew S · West Hartford, CTBuilt 2000 · S/N 29-0228 N2222SFlyfoxco LLC · Dover, DEBuilt 2023 · S/N 9579 N22232Engeseth James Jr · Parker, COBuilt 1972 · S/N 21059730 N2224FE C Nelson Inc · Rio Oso, CABuilt 2000 · S/N 30-0051 N2225Ica Aviation LLC · Alexandria, VABuilt 2018 · S/N 4614 N2226LSlyngstad Todd · San Jose, CABuilt 1999 · S/N EA-640 N2228DAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 29-0246 N2228KSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 29-0269 N2229FMulligan Aviation LLC · Janesville, WIBuilt 2000 · S/N 29-0235 N2229SKey Lime Consultants LLC · Wilmington, DEBuilt 1976 · S/N 21061174 N222AHN222ah LLC · Key Largo, FLBuilt 2024 · S/N 10382 N222ALBca Aviation LLC · Pataskala, OHBuilt 2022 · S/N 8520 N222AXGraven Timothy G · Foristell, MOBuilt 1970 · S/N 414-0078 N222BANimbus Aviation LLC · Bellevue, WABuilt 2011 · S/N 0263 N222BGBeaumont David Matthew · Orcutt, CABuilt 2004 · S/N 1095 N222BJFlight Smith LLC · Orem, UTBuilt 1972 · S/N 414-0264 N222BTBt4 Holdings LLC · The Villages, FLBuilt 2018 · S/N 4726 N222BUDarrowby LLC · Medina, MNBuilt 2026 · S/N 11318 N222BYRda Solutions LLC · Fort Worth, TXBuilt 2004 · S/N 41022 N222CFTachys Aviation LLC · Bee Cave, TXBuilt 2018 · S/N 1736 N222DDInternational Air Services Inc Trustee · Carson City, NVBuilt 2018 · S/N 1745 N222DKVestal Randy L · Darien, GABuilt 1982 · S/N 25-0721 N222DQMda Aviation LLC · Darby, MTBuilt 2022 · S/N 8768 N222DVAvs Aircraft LLC · Brentwood, TNBuilt 2011 · S/N 0168 N222EDInternational Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N 1103 N222FGSkytravel LLC · Victoria, TXBuilt 1981 · S/N 414A0823 N222GSLandau Management Services Inc · Topanga, CABuilt 1981 · S/N TJ384 N222GXBorchert Ronald L · Richfield, OHBuilt 2005 · S/N 29-0367 N222HCMuddflyers LLC · Woodbridge, VABuilt 1981 · S/N EA-259 N222HDPink Panther Aviation LLC · Boston, MABuilt 2024 · S/N 10256 N222HSSal Aviation LLC · Port Orange, FLBuilt 2023 · S/N 9462 N222JFCline Denis Jay Trustee · Colton, CABuilt 2004 · S/N 29-0331 N222LDHrt Aviation LLC · Charleston, SCBuilt 2006 · S/N 1838 N222LSLj Bickford Companies LLC · Wasilla, AKBuilt 1972 · S/N U206-01751 N222MDElx Aviation LLC · Hartford, MIBuilt 1974 · S/N 310Q1013 N222PLAnderas Per R · Green Bay, WIS/N 414A0521 N222PRFlying South LLC · Wilmington, DEBuilt 1973 · S/N 4140384 N222RBM & B Llp · Iowa City, IABuilt 1990 · S/N TH-1592 N222RDAviation Consultants Inc · San Luis Obispo, CABuilt 1977 · S/N 340A-0366 N222RGVaerus Jet Sales LLC · Topeka, KSBuilt 1994 · S/N TH-1698 N222RMKelco LLC · Helena, MTBuilt 1971 · S/N 414-0168 N222RQHi Point Aviation LLC · Carson City, NVBuilt 2011 · S/N 0264

Back to AD 2012-10-13