Registered aircraft · 3,673

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

N1001XB Ryan Enterprises Inc · Lynnfield, MABuilt 2012 · S/N LIV-459 N100DGCirrus Sr22t 2190 Inc Trustee · Wilmington, DEBuilt 2024 · S/N 9952 N100JCTriple Two Holdings LLC · Naples, FLBuilt 2017 · S/N 1542 N100PKAllen Chase Enterprises Inc · Oswego, NYBuilt 2024 · S/N 10294 N100RZEastern Stearman Inc Trustee · Leesburg, VABuilt 2010 · S/N 0034 N100YWMps Aviation LLC · The Villages, FLBuilt 2020 · S/N 2215 N1014ARegistered aircraftBuilt 2017 · S/N 1646 N101FRFoxfly LLC · Red Bank, NJBuilt 2013 · S/N T24002037 N101TPSamurai Ventures LLC · Hillsborough, CABuilt 2025 · S/N 10479 N10222Willard Gregory M · Bonita Springs, FLBuilt 2009 · S/N 411141 N1024ZAqua Men Service LLC · Temple, GABuilt 2005 · S/N 41097 N102ARValiair Limited Co Trustee · Casper, WYBuilt 2013 · S/N 0463 N102HCMerz Investments LLC · Renton, WABuilt 2024 · S/N 10285 N102TXAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2012 · S/N 0412 N10332Tx Holdings · Hermosa Beach, CABuilt 2009 · S/N 411132 N1036PHeyden Aviation LLC · Alpharetta, GABuilt 2009 · S/N 411138 N103BKFalcon Avion LLC · Paragould, ARBuilt 2025 · S/N 10668 N103JGRam Aero Development Inc · Waco, TXBuilt 1979 · S/N 414A0264 N103KEuroaviation Inc Trustee · KematenBuilt 2023 · S/N 10193 N103LCKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2021 · S/N 2281 N103PFQuality Protection Inc · Springfield, MOBuilt 2008 · S/N 411092 N104PPToledo Public Schools · Swanton, OHS/N 41086 N104SVCrete Solutions LLC · Wilmington, NCBuilt 2025 · S/N 11053 N1052AKraken Aviation LLC · Camden, DEBuilt 2016 · S/N 1333 N10580Dwyer Lawrence William · Berthoud, COS/N 411150 N1058ZBaillie Richard Leslie · Newark, DEBuilt 2008 · S/N 411058 N105GCCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 11013 N105LWCan You See Me Now LLC · Dakota Dunes, SDBuilt 2024 · S/N 9852 N105PKMendel Aviation LLC · Albuquerque, NMBuilt 2023 · S/N 9235 N105PZPca Leasing LLC · Heber City, UTBuilt 2009 · S/N L2K-295 N105RGVictor Aviation LLC · St George, UTBuilt 2013 · S/N T24002013 N106JSBlok Air Inc · Brookings, SDBuilt 2018 · S/N 1661 N106MCLappland LLC · Camden, DEBuilt 2019 · S/N 1877 N107AXCirrusly Flying LLC · Issaquah, WABuilt 2017 · S/N 1519 N107BBTer-Bear LLC · Payson, AZBuilt 2016 · S/N 1235 N107GKYoung William L · Boston, MABuilt 2014 · S/N 0790 N107MYTeatree LLC · Incline Village, NVBuilt 2018 · S/N 1751 N1087TCampagna Thomas B · Midland, TXBuilt 2008 · S/N 411033 N108LCTryzub Air LLC · Somerville, MABuilt 2013 · S/N 0535 N108LWTraceair LLC · Mountain Home, NCBuilt 2014 · S/N 0872 N108VVCiferno Aviation LLC · Rostraver Township, PABuilt 2024 · S/N 9909 N1096WOstroff Alan · Pleasanton, CABuilt 2023 · S/N 9053 N109SDBelcher William · Lancaster, NYBuilt 2019 · S/N 1857 N10ACNext Flight LLC · Nokomis, FLBuilt 2022 · S/N 8782 N10BManasota Aviation LLC · Saint Petersburg, FLBuilt 2022 · S/N 8963 N10CDAvbase Flight Group Inc Trustee · Wilmington, DEBuilt 2012 · S/N 0350 N10HQAndjul Aviation LLC · Palm Beach, FLBuilt 2024 · S/N 10243 N10KKMensch Air LLC · Miami, FLBuilt 2022 · S/N 8975 N10PXHls Equipment LLC · Spokane Valley, WABuilt 2016 · S/N 1453 N10RDValiair Lc Trustee · Casper, WYBuilt 2023 · S/N 9300

Back to AD 2016-21-04