Registered aircraft · 671

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:2001-02-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:2001-02-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:2001-02-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:2001-02-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:2001-02-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:2001-02-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.

N333SLT C Air LLC · West Linn, ORBuilt 2021 · S/N 525-1083 N333XAJetnexa One LLC · Gilbert, AZBuilt 2015 · S/N 525-0889 N33DTN33dt LLC · Phoenix, AZBuilt 1995 · S/N 525-0080 N33FWNext Level Aviation Group LLC · Sarasota, FLBuilt 1997 · S/N 525-0203 N33NMBighorn Airways Inc · Sheridan, WYBuilt 1993 · S/N 5250025 N341ARMla Management LLC · Salt Lake City, UTBuilt 1999 · S/N 525-0341 N347BCRoni 1 LLC · Sacramento, CABuilt 2001 · S/N 525-0431 N34RLKar2 Inc · Sevierville, TNBuilt 2017 · S/N 525-0948 N34TCHuff Air LLC · Uvalde, TXBuilt 1994 · S/N 5250083 N351BCInternational Bank Of Commerce · Laredo, TXBuilt 1996 · S/N 525-0159 N351BFKbs Aviation LLC · Springboro, OHBuilt 2018 · S/N 525-0995 N358HAElsy Equipment LLC · Owasso, OKBuilt 1999 · S/N 525-0358 N360SHRkjm LLC · Superior, NEBuilt 1997 · S/N 525-0201 N363BSMjti LLC · Santa Rosa, CABuilt 2017 · S/N 525-0961 N364PKSky Hawk LLC · Moody, ALBuilt 1999 · S/N 525-0320 N365SMIntegrated Transportation Services LLC · Tupelo, MSBuilt 2007 · S/N 525-0658 N365SNNice Neighbors LLC · Wilmington, NCBuilt 1996 · S/N 525-0121 N36RGJrb Of Montana LLC · Wooster, OHBuilt 1996 · S/N 525-0139 N36TXFrog Air LLC · Amarillo, TXBuilt 1996 · S/N 525-0153 N371RMFwd&L 525 LLC · Cataula, GABuilt 2015 · S/N 525-0900 N373AFSe Aero II LLC · Atoka, OKBuilt 1999 · S/N 525-0308 N377PGJackalope Air LLC · Afton, WYBuilt 2022 · S/N 525-1133 N38RLAtg112 LLC · Reno, NVBuilt 2001 · S/N 525-0420 N390KTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 525-0813 N392RGWhitt Aviation LLC · Lannon, WIBuilt 1999 · S/N 525-0340 N392SMHarrison Aviation LLC · Yuma, AZBuilt 2000 · S/N 525-0392 N394GAAircraft Owners And Pilots Association · Frederick, MDBuilt 2013 · S/N 525-0807 N399ABRkwa LLC · Shreveport, LABuilt 2018 · S/N 525-0990 N399G399g LLC · Moody, ALS/N 525-0183 N399PDSpraytec Aviation Inc · Urbandale, IABuilt 2025 · S/N 525-1190 N39CJBagwell Aviation LLC · Raleigh, NCBuilt 1993 · S/N 525-0039 N3JSOriole Capital LLC · Wilmington, DEBuilt 2020 · S/N 525-1052 N3SWAero Burro LLC · San Antonio, TXBuilt 2002 · S/N 525-0501 N400MZParker Long LLC · Lexington, NCBuilt 2025 · S/N 525-1400 N4047SCvj62b LLC · Hendersonville, TNBuilt 2022 · S/N 525-1121 N408RKPolar Palms LLC · Helena, MTBuilt 2015 · S/N 0860 N40CJInco Investments LLC · San Jose, CABuilt 2004 · S/N 525-0540 N411VRAirtrust LLC -10-Series 10 Trustee · Sheridan, WYBuilt 2001 · S/N 525-0411 N417QC P Holdings LLC · Watertown, SDBuilt 2000 · S/N 525-0385 N418KCHastings Steve · Corpus Christi, TXBuilt 1996 · S/N 525-0130 N425WHTransportation Services LLC · Huntsville, ALBuilt 2004 · S/N 525-0537 N426EDWindsock Aviation LLC · Bridgeport, WVBuilt 2001 · S/N 525-0426 N427KPKp Equipment LLC · Annandale, MNBuilt 2014 · S/N 525-0837 N428MGSav Aviation LLC · Jacksonville, TXBuilt 2001 · S/N 525-0457 N42ALRegistered aircraftBuilt 2014 · S/N 525-0836 N42KKBlack Car Logistics LLC · Wausau, WIBuilt 2025 · S/N 525-1401 N430BTDry Valley Investors LLC · Cleveland, TNBuilt 2001 · S/N 5250451 N430JFAusome Aviation LLC · Atlanta, GABuilt 2004 · S/N 525-0530 N430UHTextron Aviation Inc · Wichita, KSS/N 525-1430 N432PPatterson Aviation LLC · Midland, TXBuilt 2006 · S/N 525-0624

Back to AD 2001-02-13