Registered aircraft · 5,649

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

N1000V1kv LLC · Moultrie, GAS/N 0660 N100FRQualitair LLC Trustee · MichelstadtBuilt 2003 · S/N 0770 N100JBAirbyars LLC · Spartanburg, SCBuilt 2024 · S/N 10290 N100MJMh Aviation LLC · Glendale, AZBuilt 2007 · S/N 2844 N100PXS & R Air LLC · Amarillo, TXBuilt 2004 · S/N 0953 N100WMValiair Lc Trustee · Casper, WYBuilt 2005 · S/N 1268 N100XZJjk Aviation LLC · Hartland, WIBuilt 2024 · S/N 10040 N100YYInternational Air Services Inc Trustee · Carson City, NVBuilt 2002 · S/N 1183 N100YZCay Air LLC · North Palm Beach, FLBuilt 2004 · S/N 0814 N100ZWFetch Aviation LLC · Bonita Springs, FLBuilt 2014 · S/N 4086 N1011GInternational Air Services Inc Trustee · Carson City, NVBuilt 2025 · S/N 10795 N1019PBoondocks Solutions LLC · Tomball, TXS/N 1037 N101BEOne Bravo Echo LLC · Fernandina Beach, FLBuilt 2011 · S/N 3759 N101CDCharlie Delta Aviation LLC · Marietta, GABuilt 2001 · S/N 0101 N101FKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2008 · S/N 3027 N101GWPlan B Air LLC · Lago Vista, TXBuilt 2007 · S/N 2528 N101MRStick The Landing Aviation LLC · Radford, VABuilt 2006 · S/N 1732 N101MWMaroon Creek LLC · Aspen, COBuilt 2007 · S/N 2823 N101NSNoyes Gerold W · Northfield Falls, VTBuilt 2005 · S/N 1588 N101VMKrowel Nicholas E · Woodstock, GABuilt 2001 · S/N 0109 N101XMMaier Gerard · Hartford, WIBuilt 2004 · S/N 1226 N101ZACirrus Sr22 10117 Inc Trustee · Wilmington, DEBuilt 2024 · S/N 10117 N102CDSch Aviation Inc Trustee · Sporle Kings LynnBuilt 2000 · S/N 1016 N102CJJordan River Aviation LLC · Madisonville, KYBuilt 2002 · S/N 1237 N102DWFlyboy Aviation LLC · Memphis, TNBuilt 2006 · S/N 1750 N102GGVictor Airways LLC · Canton, GABuilt 2021 · S/N 2730 N102JSRegistration Pending · Cresco, PARegistration pendingBuilt 2024 · S/N 9919 N102KWVentura Douglas · Cambridge, MDBuilt 2003 · S/N 0755 N102LTSandjuice LLC · Gainesville, FLBuilt 2002 · S/N 0288 N102PBDeland Air And Sea Brokerage Inc · Deland, FLS/N 0321 N102SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 1864 N102VAVectored Aircraft Leasing LLC · Austin, TXBuilt 2025 · S/N 10511 N103CClarity Its LLC · Canton, GABuilt 2002 · S/N 0432 N103EECirrus Djh LLC · Bountiful, UTBuilt 2006 · S/N 2104 N103ERR & J Aviation LLC · Bloomfield Hills, MIBuilt 2016 · S/N 2321 N103FDMidnight Echo LLC · Miami Lakes, FLBuilt 2024 · S/N 9838 N103MK2141 Corp · Wilmington, DEBuilt 2005 · S/N 1444 N103VAA-Team Aviation LLC · Austin, TXBuilt 2025 · S/N 10788 N104BZSterling Aviation LLC · Newport Beach, CABuilt 2004 · S/N 1219 N104ETLmc Angels LLC · Hinckley, OHBuilt 2004 · S/N 1024 N104GHBluff Point Aviation LLC · Jensen Beach, FLBuilt 2014 · S/N 4087 N104KVKatiegirl Aviation LLC · Stockton, CABuilt 2021 · S/N 2683 N104TQGtw Aviation LLC · San Jose, CABuilt 2006 · S/N 2304 N10502Flying Chipmunk LLC · Charlotte, NCBuilt 2025 · S/N 10502 N105CKHdm Aviation LLC · Saratoga, CABuilt 2016 · S/N 4399 N105HCJi Aviation LLC · Vidalia, LABuilt 2019 · S/N 4777 N105KLWing It LLC · Madison, WIBuilt 2017 · S/N 4461 N105MUMarshall University · Huntington, WVBuilt 2020 · S/N 2625 N105TTW&P Aircraft LLC · Humble, TXBuilt 2006 · S/N 1867 N105WLSchmitt Family Holdings LLC · Independence, IABuilt 2006 · S/N 2210

Back to AD 2002-24-08