Registered aircraft · 1,631

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:2008-11-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:2008-11-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:2008-11-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:2008-11-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:2008-11-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:2008-11-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.

N100XZJjk Aviation LLC · Hartland, WIBuilt 2024 · S/N 10040 N100YYInternational Air Services Inc Trustee · Carson City, NVBuilt 2002 · S/N 1183 N1019PBoondocks Solutions LLC · Tomball, TXS/N 1037 N101MRStick The Landing Aviation LLC · Radford, VABuilt 2006 · S/N 1732 N101NSNoyes Gerold W · Northfield Falls, VTBuilt 2005 · S/N 1588 N102CDSch Aviation Inc Trustee · Sporle Kings LynnBuilt 2000 · S/N 1016 N102CJJordan River Aviation LLC · Madisonville, KYBuilt 2002 · S/N 1237 N102GGVictor Airways LLC · Canton, GABuilt 2021 · S/N 2730 N102JSRegistration Pending · Cresco, PARegistration pendingBuilt 2024 · S/N 9919 N102VAVectored Aircraft Leasing LLC · Austin, TXBuilt 2025 · S/N 10511 N103ERR & J Aviation LLC · Bloomfield Hills, MIBuilt 2016 · S/N 2321 N103VAA-Team Aviation LLC · Austin, TXBuilt 2025 · S/N 10788 N104KVKatiegirl Aviation LLC · Stockton, CABuilt 2021 · S/N 2683 N105MUMarshall University · Huntington, WVBuilt 2020 · S/N 2625 N106CDAerou LLC · Oviedo, FLBuilt 2000 · S/N 1015 N106LUBluewater Plumbing Service LLC · Wilmington, NCBuilt 2005 · S/N 1501 N106MUMarshall University · Huntington, WVBuilt 2021 · S/N 2682 N107CDKhalil Hassan · Clarks Summit, PABuilt 2000 · S/N 1018 N107MUMarshall University · Huntington, WVBuilt 2021 · S/N 2784 N108MGSr20 Holdings LLC · Coral Springs, FLBuilt 2023 · S/N 9431 N109WKEast Bay Trading Co · Fairview, PABuilt 2004 · S/N 1400 N10UWHorton Raymond Trustee · Phoenix, AZBuilt 2025 · S/N 11054 N1108TSale Reported · Crystal, MNSale reportedBuilt 2011 · S/N 2114 N110BWAtwater David C · Pompano Beach, FLS/N 1538 N110WKCirrus Design Corp · Duluth, MNBuilt 2011 · S/N 2115 N111RTJcec LLC · Washington Tr, UTBuilt 2001 · S/N 1156 N113BBN113bb LLC · Jamul, CABuilt 2021 · S/N 2722 N1144GLean Of Peak Aviation LLC · Kempner, TXBuilt 2020 · S/N 2592 N114BSBravo Sierra LLC · Seattle, WABuilt 2002 · S/N 1192 N114CACirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11535 N115APFp Aviator LLC · East Setauket, NYBuilt 2022 · S/N 8565 N115AVPonyup Aviation LLC · Cleveland, OHBuilt 2023 · S/N 9250 N11770Cirrus Design Corp · Duluth, MNS/N 11770 N117KDCirrus Pompano Flyers Inc · Fort Lauderdale, FLBuilt 2000 · S/N 1072 N117LFD&E Aircraft LLC · Newark, OHBuilt 2012 · S/N 2148 N119ANClear Skies Aviation LLC · Broadlands, VABuilt 2020 · S/N 2547 N119MKFlatirons Aviation LLC · Naples, FLBuilt 2011 · S/N 2084 N119RPTrdz LLC · El Segundo, CABuilt 2018 · S/N 2457 N11PSPro Ag Aviation LLC · Luverne, MNBuilt 2025 · S/N 10497 N11SUSouthern Utah University · Cedar City, UTBuilt 2017 · S/N 2359 N11WZVip Poppy LLC · Sheridan, WYBuilt 2022 · S/N 8640 N11XTKacur John Edward Sr · Halethorpe, MDBuilt 2000 · S/N 1103 N120MXSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2015 · S/N 2281 N120TKNew Leaf Consulting Inc · Raleigh, NCBuilt 2012 · S/N 2156 N1218PMcc Aero LLC · Douglas, NDBuilt 2006 · S/N 1677 N122DZFitzpatrick Nolan · Urbandale, IABuilt 2004 · S/N 1465 N122FAFox Alpha LLC · Londonderry, NHBuilt 2004 · S/N 1452 N122MXAce Aviation LLC · Parkersburg, WVBuilt 2017 · S/N 2347 N123ANSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 1379 N123CGLmadif LLC · Kaukauna, WIBuilt 2003 · S/N 1317

Back to AD 2008-11-18