Registered aircraft · 967

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

N168PXCitadel Aviation Investments LLC · Las Vegas, NVBuilt 2004 · S/N 680-0002 N168TYCoast Walk Aviation LLC · La Jolla, CABuilt 2010 · S/N 510-0297 N16CPWalmart Inc · Bentonville, ARBuilt 2016 · S/N 680-0567 N16GSJag Leasing LLC · Abbeville, ALBuilt 2025 · S/N 680A0439 N171AACorsair Two LLC · Hillsboro, ORBuilt 2012 · S/N 510-0412 N171UTImport Auto Mex Lc · Laredo, TXBuilt 2013 · S/N 510-0434 N1744ZSkidmo Aviation LLC · Missoula, MTBuilt 2011 · S/N 510-0345 N178RHNci Group Inc · Cary, NCBuilt 2007 · S/N 680-0178 N178SFWings Jet Flight Training LLC · Los Angeles, CABuilt 2008 · S/N 510-0128 N179PFRegistered aircraftBuilt 2017 · S/N 680-0574 N17EJCore Air LLC · North Charleston, SCBuilt 2007 · S/N 680-0141 N17RPGzs Aviation LLC · Dover, DEBuilt 2008 · S/N 510-0133 N17TRMustang510rf LLC · Kalispell, MTBuilt 2009 · S/N 510-0220 N17ZPWalmart Inc · Bentonville, ARBuilt 2016 · S/N 680-0566 N1866MPegasus IV LLC · Nashville, TNBuilt 2006 · S/N 680-0080 N186M186m LLC · Henderson, NVBuilt 2007 · S/N 510-0020 N1888Flying Pigs Aviation LLC · Los Altos, CABuilt 2008 · S/N 510-0107 N188TLBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 680-0257 N18KWWcs Inc · Troy, ALBuilt 2011 · S/N 680-0323 N18WELookout Air Inc · Marietta, GABuilt 2011 · S/N 680-0317 N1930JJohnson & Johnson Aviation LLC · Wilmington, DEBuilt 2015 · S/N 680-0555 N1934FMeijer Distribution Inc · Grand Rapids, MIBuilt 2025 · S/N 680A0448 N1956AAubuchon James F Jr · Mckinney, TXBuilt 2010 · S/N 510-0305 N198SBCyppress Aviation LLC · Sellersburg, INBuilt 2004 · S/N 680-0020 N1990GCkg Ventures LLC · Little Rock, ARBuilt 2016 · S/N 680A0013 N199MLColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 2007 · S/N 510-0002 N19MKGp One LLC · Denver, COBuilt 2010 · S/N 680-0304 N19RPN19rp LLC · Wilmington, DEBuilt 2014 · S/N 510-0449 N1PRPrm Corp · Pasadena, CAFirst renewal noticeBuilt 2013 · S/N 680-0340 N1QEApf Development II LLC · Naples, FLBuilt 2006 · S/N 680-0067 N1RGKar2 Inc · Sevierville, TNBuilt 2008 · S/N 510-0079 N1RSHotel Sierra Group LLC · Kittery, MEBuilt 2008 · S/N 510-0105 N1THPony Investments LLC · Colorado Springs, COBuilt 2008 · S/N 510-0076 N1UACrimson Tide Foundation · Tuscaloosa, ALFirst renewal noticeBuilt 2011 · S/N 680-0312 N1VV565 Vv Ltd · Union Hill, ILBuilt 2007 · S/N 510-0013 N1ZCZachry Industrial Inc · San Antonio, TXBuilt 2006 · S/N 680-0085 N200DZMax Aircraft LLC · Coraopolis, PABuilt 2008 · S/N 680-0243 N2026LDelta Bravo Operations LLC · Wilmington, DEBuilt 2026 · S/N 680A0483 N2069QAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2008 · S/N 510-0137 N208MFCaledonia Leasing LLC · Mundelein, ILBuilt 2008 · S/N 680-0233 N20HHubbard Broadcasting Inc · Saint Paul, MNBuilt 2012 · S/N 680-0338 N20MKTrt Equity Advisors LLC · Dallas, TXBuilt 2017 · S/N 680-0573 N210PMAlpha Bravo LLC · Knoxville, TNBuilt 2010 · S/N 510-0301 N211CCOrchard Aviation LLC · Birmingham, MIBuilt 2005 · S/N 680-0034 N216STTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 680-0598 N219LCDirect Digital Leasing LLC · Charlotte, NCBuilt 2008 · S/N 680-0249 N219LDRocklyn Leasing LLC · Duluth, GABuilt 2005 · S/N 680-0032 N21H21h Leasing LLC · Los Ranchos, NMBuilt 2012 · S/N 680-0335 N21MEKgbh LLC · Kalispell, MTBuilt 2026 · S/N 680A0468 N221GKBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 680A0115

Back to AD 2018-07-13