Skip to content

Registered aircraft · 418

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

N100SBA-7 Austin Aviation LLC · Amarillo, TXBuilt 2011 · S/N 525C0061 N100YVb Ultra Transportation LLC · Lake Oswego, ORBuilt 2015 · S/N 525C0204 N100ZTBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 525C0392 N105ADComputer Service Professionals Inc DBA · Wilmington, DEBuilt 2010 · S/N 525C-0013 N109CAJaf Aviation LLC · Englewood, COBuilt 2012 · S/N 525C-0112 N10AUAuburn University · Auburn, ALBuilt 2026 · S/N 525C0493 N10GUBusiness Insurance Group LLC · Montgomery, ALBuilt 2016 · S/N 525C0210 N111BPAlabama Farmers Cooperative Inc · Decatur, ALBuilt 2023 · S/N 525C0431 N1150MBakko Aviation LLC · Glenwood, MNBuilt 2012 · S/N 525C0101 N115BATextron Aviation Inc · Wichita, KSS/N 525C0506 N116TACbp Air Logistics LLC · Statham, GABuilt 2012 · S/N 525C0116 N11AKKmg LLC · Anchorage, AKBuilt 2016 · S/N 525C0236 N11GPPowers Consulting Group LLC · Naples, FLBuilt 2024 · S/N 525C0457 N12MGBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 525C0370 N12SSShoe Show Inc · Concord, NCBuilt 2016 · S/N 525C-0219 N131MSBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 525C0337 N137JQBcm Aviation LLC · Naples, FLBuilt 2013 · S/N 525C0137 N141RTTexsun Ltd LLC · Amarillo, TXBuilt 2019 · S/N 525C0299 N14CJJh Aircraft Management Inc · Anchorage, AKBuilt 2010 · S/N 525C0001 N14WNH&H Aeronautics LLC · Gatesville, TXBuilt 2012 · S/N 525C0104 N150RCCbp Air Logistics LLC · Statham, GABuilt 2012 · S/N 525C0073 N155LPKnot For Free LLC · Fruitland Park, FLBuilt 2012 · S/N 525C0110 N159HLkw Inc · Portsmouth, NHBuilt 2015 · S/N 525C0195 N163MData Center Services Leasing LLC · Salem, ORBuilt 2011 · S/N 525C0035 N180RCBirdies Wings LLC · Sioux Falls, SDBuilt 2014 · S/N 525C0147 N181CHNew Cj4 LLC · Bartlett, ILBuilt 2010 · S/N 525C0015 N181CNContrails II Inc · Wilmington, DEBuilt 2011 · S/N 525C0040 N184GTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2022 · S/N 525C0391 N1886XAcord Transportation Inc · Chandler, OKBuilt 2014 · S/N 525C0162 N1895CGottemoeller Aircraft Leasing Ltd · Fort Loramie, OHBuilt 2022 · S/N 525C0373 N18MMEf Capital Management Aviation LLC · The Woodlands, TXBuilt 2019 · S/N 525C0302 N18ZDBar S U Inc DBA · Fort Morgan, COBuilt 2018 · S/N 525C0262 N191SAScheffler Air LLC · Henderson, NVBuilt 2013 · S/N 525C-0142 N194MESoj-Hfg LLC · Austin, TXBuilt 2017 · S/N 525C0259 N19BWCapitan Peak LLC · Mesquite, NMBuilt 2020 · S/N 525C0329 N1KRegistered aircraftBuilt 2022 · S/N 525C0390 N1MGHagedorn Aviation Inc · Columbus, OHBuilt 2017 · S/N 525C-0246 N2020Eye Fly Inc · North Caldwell, NJBuilt 2019 · S/N 525C0295 N207CJAlliant Partners LLC · Moody, ALS/N 525C0207 N20AUAuburn University · Auburn, ALBuilt 2021 · S/N 525C0351 N20LCDon Oppliger Trucking Inc · Amarillo, TXBuilt 2012 · S/N 525C0102 N20MTJ M Thomas Forest Products Company · Ogden, UTBuilt 2022 · S/N 525C0386 N2112Rocinante Air LLC · Wilmington, DEBuilt 2014 · S/N 525C0159 N217RMRoland Charter Service LLC · Springfield, ILBuilt 2015 · S/N 525C0202 N218MBMbi Leasing LLC · Bismarck, NDBuilt 2020 · S/N 525C0331 N219GRN219gr LLC · Vevay, INBuilt 2020 · S/N 525C0340 N219LEstrella Aviation III LLC · Phoenix, AZBuilt 2011 · S/N 525C0023 N21TQAntair Sd LLC · Brandon, SDBuilt 2016 · S/N 525C0228 N221SShiprock Holdings LLC · Santa Fe, NMBuilt 2018 · S/N 525C0288 N22503Rainmaker Lawyer Marketing Inc · Fort Lauderdale, FLBuilt 2012 · S/N 525C0083

Back to AD 2011-21-51