Skip to content

Registered aircraft · 335

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

N102UFly Rocket LLC · San Marcos, TXBuilt 2003 · S/N C0205 N107CLDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 1998 · S/N C0007 N107TXSweet Aviation LLC · Fort Wayne, INBuilt 2005 · S/N C0310 N108CLTcm Flying Club Inc · Mobile, ALBuilt 1998 · S/N C0008 N110CTPremier Pilot Training LLC · Camp Hill, PABuilt 2000 · S/N C0110 N113CLDa Adventures LLC · Hermitage, TNBuilt 1998 · S/N C0013 N116CLWem Aviation LLC · Goldsboro, NCBuilt 1998 · S/N C0016 N118CLIndiana State University · Terra Haute, INBuilt 1998 · S/N C0018 N120ASSkyline Aviation Inc · San Angelo, TXBuilt 2022 · S/N C0729 N125ASSkyline Aviation Inc · San Angelo, TXBuilt 2025 · S/N C0781 N127ASSkyline Aviation Inc · San Angelo, TXBuilt 2022 · S/N C0730 N133ASSkyline Aviation Inc · San Angelo, TXBuilt 2023 · S/N C0758 N133DATake Flight Aviation LLC · Montgomery, NYBuilt 2012 · S/N C0623 N134ASSkyline Aviation Inc · San Angelo, TXBuilt 2022 · S/N C0735 N136MADiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 2004 · S/N C0260 N138CLKempton Larry G Jr · Grand Junction, COBuilt 1998 · S/N C0038 N139DASkywest Leasing Inc · St George, UTBuilt 2012 · S/N C0619 N141BBDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 2005 · S/N C0311 N141DKIn Flight Aircraft LLC · Howell, MIBuilt 2015 · S/N C0675 N143MALarkair LLC · Fort Wayne, INBuilt 2003 · S/N C0243 N143TXCae Doss Aviation Inc · Pueblo, COBuilt 2006 · S/N C0412 N144TXCae Doss Aviation Inc · Pueblo, COBuilt 2007 · S/N C0414 N146DRInternational Air Services Inc Trustee · Carson City, NVBuilt 1999 · S/N C0069 N148ASSkyline Aviation Inc · San Angelo, TXBuilt 2025 · S/N C0782 N148DADragonfly Aviation LLC · Winder, GABuilt 2001 · S/N C0146 N153MAGlide Air LLC · Coral Gables, FLBuilt 2004 · S/N C0261 N157ASSkyline Aviation Inc · San Angelo, TXBuilt 2023 · S/N C0759 N159ASSkyline Aviation Inc · San Angelo, TXBuilt 2023 · S/N C0760 N161CAAerodynamic LLC · Aurora, ORS/N C0372 N163ASSkyline Aviation Inc · San Angelo, TXBuilt 2022 · S/N C0736 N164ASSkyline Aviation Inc · San Angelo, TXBuilt 2022 · S/N C0737 N167DCJc Aviation LLC · Springville, UTBuilt 2001 · S/N C0167 N168DCTailwind Aviation Solutions LLC · Perry, GABuilt 2001 · S/N C0168 N169PSTactical Integrated Training Solutions LLC · Colorado Springs, COS/N C0169 N173ASSkyline Aviation Inc · San Angelo, TXBuilt 2025 · S/N C0783 N176ASSkyline Aviation Lnc · San Angelo, TXBuilt 2022 · S/N C0738 N180SEAdams Aviation Services Inc Trustee · Wilmington, DES/N C0280 N181ASPremier Aircraft Sales Inc · Fort Lauderdale, FLS/N C0792 N194ASSkyline Aviation Inc · San Angelo, TXBuilt 2022 · S/N C0739 N196ASSkyline Aviation Inc · San Angelo, TXBuilt 2022 · S/N C0740 N201AVN340ja LLC · Manassas, VABuilt 2007 · S/N C0461 N203BLAmerican Asset Leasing LLC · Aurora, ORS/N C0161 N203DCWorld Class Aviation Ltd · Bellefontaine, OHBuilt 2003 · S/N C0203 N205BLDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 2003 · S/N C0249 N208NHFlight Club 502 · Louisville, KYBuilt 1998 · S/N C0027 N209ND209nd Aircraft Leasing LLC · Spanish Fork, UTBuilt 1998 · S/N C0023 N213ASSkyline Aviation Inc · San Angelo, TXBuilt 2023 · S/N C0755 N215LAAurora Leasing LLC · Woods Cross, UTBuilt 2024 · S/N C0766 N220NHN220nh Aircraft Leasing LLC · Payson, UTBuilt 1998 · S/N C0028 N223DCGumps LLC · Jersey City, NJBuilt 2007 · S/N C0452

Back to AD 2026-15-18