Skip to content

Registered aircraft · 158

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

N1088YRegistered aircraftBuilt 2018 · S/N 65139 N108LGSaje Aviation Inc · Calabasas, CABuilt 2021 · S/N 65357 N121AEAea Aviation LLC · Purchase, NYBuilt 2024 · S/N 65605 N121TATurf Air LLC · East Northport, NYBuilt 2019 · S/N 65239 N1243YTurbines Ltd · West Point, NEBuilt 2018 · S/N 65137 N12YAHelicopters Inc · Wilmington, DEBuilt 2018 · S/N 65103 N13RMIndigo Aviation Inc · Savannah, GABuilt 2021 · S/N 65372 N14JBPbs Holdings LLC · Missoula, MTBuilt 2024 · S/N 65594 N153LLLee Aviation Services LLC · Wilson, NCBuilt 2019 · S/N 65227 N181RN181r LLC · Fort Lauderdale, FLBuilt 2021 · S/N 65359 N192RBWestern Pilot Service Inc · Phoenix, AZBuilt 2017 · S/N 65022 N196TVGriffin Television Tulsa LLC · Oklahoma City, OKBuilt 2024 · S/N 65512 N225BAR&R Testing Inc · Watertown, SDBuilt 2025 · S/N 65690 N240PDCity Of Omaha · Omaha, NEBuilt 2019 · S/N 65177 N24CZWestern Sky Aviation LLC · Scottsdale, AZBuilt 2018 · S/N 65142 N279PDCity Of Sacramento · Sacramento, CABuilt 2018 · S/N 65102 N296RBell Textron Inc · Fort Worth, TXBuilt 2022 · S/N 65379 N29ARN29ar LLC · Macon, GABuilt 2019 · S/N 65214 N300GDJem Spin LLC · Bedford, NHBuilt 2022 · S/N 65427 N306FDCity Of Los Angeles · Van Nuys, CABuilt 2023 · S/N 65520 N307FDCity Of Los Angeles · Van Nuys, CABuilt 2022 · S/N 65421 N30BHHover Partners LLC · Fort Worth, TXBuilt 2018 · S/N 65090 N313FLCae USA Inc · Tampa, FLBuilt 2023 · S/N 65466 N314VDOtd Aviation LLC · Bethesda, MDBuilt 2018 · S/N 65101 N318GVWings & Rotor LLC · Wilmington, DEBuilt 2019 · S/N 65221 N32APGlaze Adams Enterprises LLC · North Little Rock, ARBuilt 2019 · S/N 65268 N337APAir Panthere LLC · Phoenix, AZBuilt 2024 · S/N 65588 N337HGHappy Heli Holdings LLC · Flint, MIBuilt 2021 · S/N 65337 N340PDCity Of Omaha · Omaha, NEBuilt 2023 · S/N 65497 N347CSLeon County Florida · Tallahassee, FLBuilt 2020 · S/N 65272 N356BPIntermountain Air Inc · Colorado Springs, COBuilt 2022 · S/N 65451 N35CBBlackhawk 787 LLC · Columbus, OHBuilt 2022 · S/N 65444 N361CTTwo Blades LLC · Port Orange, FLBuilt 2024 · S/N 65603 N373NENebraska State Patrol · Lincoln, NEBuilt 2021 · S/N 65364 N394MB78cl Aviation LLC · Ogden, UTBuilt 2018 · S/N 65127 N404CJRyan Investments LLC · Yuma, AZBuilt 2023 · S/N 65468 N42JBAlliance Aircraft Sales Inc · Pierre, SDBuilt 2018 · S/N 65091 N442LNMead Zane · Lubbock, TXBuilt 2019 · S/N 65265 N451LCBlue Wings Aviation LLC · Summerfield, NCBuilt 2023 · S/N 65495 N459PTGlc Ventures Capital Holdings LLC · Ponder, TXBuilt 2020 · S/N 65292 N45VGJunfer Flyers LLC · Wilmington, DEBuilt 2024 · S/N 65590 N473LCFly LLC · Midland, TXBuilt 2024 · S/N 65575 N479LKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2018 · S/N 65111 N500WTN-Flight LLC · Kenedy, TXBuilt 2021 · S/N 65346 N504XHaidar Aviation LLC · Dallas, TXBuilt 2020 · S/N 65313 N505AJJet Ranger X LLC · Anchorage, AKBuilt 2018 · S/N 65085 N505BMBrister Aviation LLC · Amarillo, TXBuilt 2023 · S/N 65469 N505BTBell Textron Inc · Fort Worth, TXBuilt 2018 · S/N 65169 N505BVImmec Logistics LLC · Social Circle, GABuilt 2024 · S/N 65550 N505CSGracie Mae LLC · Helena, MTBuilt 2019 · S/N 65284

Back to AD 2023-24-09