Skip to content

Registered aircraft · 1,017

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

N100UVJohn B Bateman · Draper, UTBuilt 2004 · S/N 40.405 N1015THarris Nail Investments LLC · Granbury, TXBuilt 2021 · S/N 40.NC149 N101JPKrouse Donald E · Weaverville, CABuilt 2002 · S/N 40.218 N102UVFrequency Change Aviation Services Inc · Nashville, TNBuilt 2005 · S/N 40.549 N103UVUtah Valley University · Orem, UTBuilt 2006 · S/N 40.683 N104JASkywest Leasing Inc · Saint George, UTBuilt 2004 · S/N 40.440 N104UVUtah Valley University · Orem, UTBuilt 2006 · S/N 40.684 N105UVUtah Valley University · Orem, UTBuilt 2006 · S/N 40.685 N106UVUtah Valley University · Orem, UTBuilt 2006 · S/N 40.686 N107KCRandall Frederick Kuchenmeister · New Baltimore, MIBuilt 2011 · S/N 40.1126 N107UVUtah Valley University · Orem, UTBuilt 2009 · S/N 40.1030 N108CFCentral Flying Service LLC · Little Rock, ARBuilt 2005 · S/N 40.479 N108UVUtah Valley University · Orem, UTBuilt 2003 · S/N 40.342 N109UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1214 N110UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1216 N112UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1217 N113NGSkybound Aviation LLC · Easley, SCBuilt 2018 · S/N 40.NC021 N113SDCavu Pilot LLC · Powell, TNBuilt 2008 · S/N 40.1011 N113UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1218 N114UVUtah Vallet University · Orem, UTBuilt 2020 · S/N 40.1221 N115NGIveyation LLC · Pelham, NHS/N 40.NC179 N115UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1222 N116LAEntech Instruments Inc · Simi Valley, CABuilt 2023 · S/N 40.NC277 N116NGCarolina Garuda Services LLC · Wilson, NCBuilt 2011 · S/N 40.N016 N116UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1223 N118GMUtah State University · Logan, UTBuilt 2005 · S/N 40.521 N118UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1224 N119NGZl Aviation LLC · Loveland, COBuilt 2022 · S/N 40.NC180 N119UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1225 N11ZMJr Aircraft Services LLC · Oxford, MIBuilt 2004 · S/N 40.460 N120DSElement Aero LLC · Chicago, ILBuilt 2002 · S/N 40.220 N120NGWilson Scott A Trustee · New Castle, COBuilt 2020 · S/N 40.NC099 N1216Lnsda40 LLC · Lititz, PABuilt 2023 · S/N 40.NC225 N121CJCharlie Juliet Aerospace LLC · Naugatuck, CTBuilt 2005 · S/N 40.466 N121NGZt Aviation LLC · Loveland, COBuilt 2020 · S/N 40.NC100 N122NGAustin Fire Systems LLC · Christiansted, VIBuilt 2020 · S/N 40.NC108 N123MZMj Aviators LLC · Portland, ORBuilt 2010 · S/N 40.1070 N123NADecker Family Aviation LLC · Conroe, TXBuilt 2005 · S/N 40.484 N123NGFlat Canyon Da LLC · Fort Worth, TXBuilt 2021 · S/N 40.NC123 N123TVIn Flight Aircraft LLC · Howell, MIBuilt 2004 · S/N 40.432 N1244TMiddle Tennessee State University · Murfreesboro, TNBuilt 2015 · S/N 40.1191 N124SAFarrar James Calvin · Sundown, TXBuilt 2023 · S/N 40.NC242 N125HAK-14 Squadron LLC · Santa Fe, NMBuilt 2004 · S/N 40.416 N125HLRnrnp Holdings LLC · Denton, TXBuilt 2005 · S/N 40.551 N125NGNovember Golf LLC · Provo, UTBuilt 2015 · S/N 40.N261 N126USBraun Darren S · Genoa, NVBuilt 2007 · S/N 40.826 N127DSC J Aviation LLC · Kennewick, WABuilt 2018 · S/N 40.NC018 N127KCUtah State University · Logan, UTBuilt 2011 · S/N 40.1127 N127XKilgore Sky LLC · Parker, AZBuilt 2004 · S/N 40.438 N128USPacific Diamond LLC · Moraga, CABuilt 2006 · S/N 40.728

Back to AD 2022-13-06