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.

N724NNicholas Services LLC · Oxford, MSBuilt 2019 · S/N 680A0203 N724RMInterbank · Dover, DEBuilt 2011 · S/N 680-0314 N724VBRegistered aircraftBuilt 2016 · S/N 680A0051 N725JBPlane Leasing LLC · Wilmington, DEBuilt 2007 · S/N 510-0030 N72SRTrio Freedom Holdings LLC · Midland, TXBuilt 2009 · S/N 510-0264 N731DYDnd Aviation LLC · Jacksonville Beach, FLBuilt 2018 · S/N 680A0128 N733CFFlying Success LLC · Apex, NCBuilt 2015 · S/N 510-0458 N738NNicholas Services LLC · Oxford, MSBuilt 2020 · S/N 680A0244 N73FHGray Prairie LLC · Newark, DEBuilt 2008 · S/N 510-0151 N73UCDesert Sky LLC · Evansville, INBuilt 2006 · S/N 680-0086 N7402Cerium Technology Ventures LLC · Dallas, TXBuilt 2006 · S/N 680-0082 N7403Kent Investors V LLC · Grand Rapids, MIBuilt 2008 · S/N 680-0222 N740PTPoet Inc · Sioux Falls, SDBuilt 2015 · S/N 680-0544 N747KSFair Oaks Air Service LLC · San Francisco, CABuilt 2010 · S/N 510-0280 N751BGGreen Mountain Boys LLC · Orangeburg, SCBuilt 2007 · S/N 680-0181 N757AWParkdale Inc · Gastonia, NCBuilt 2021 · S/N 680A0288 N757LLSovereign Asset Co LLC · Lubbock, TXBuilt 2019 · S/N 680-0590 N758MGMgi Air Inc · Dubuque, IABuilt 2024 · S/N 680A0391 N758SP680 Private LLC · Hillside, ILBuilt 2005 · S/N 680-0015 N759SBKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2012 · S/N 510-0403 N75ESDorman Aviation LLC · Queen Creek, AZBuilt 2007 · S/N 510-0024 N760NLwa LLC · Lake Wales, FLBuilt 2011 · S/N 510-0377 N761PALos Altos Investment And Aviation Co Ltd · Las Vegas, NVNon-citizen corporation, flight hours not reportedBuilt 2011 · S/N 510-0374 N768LPJacob Stern & Sons Inc · Santa Barbara, CABuilt 2015 · S/N 680A0009 N770MWMarvin Lumber & Cedar Company LLC · Warroad, MNBuilt 2021 · S/N 680-0600 N770RMJennifer Air LLC · Mooresville, NCBuilt 2007 · S/N 680-0159 N7711BMcmorrow Gerald J · Redmond, WABuilt 2009 · S/N 510-0230 N771ESDlr Holdings LLC · Niceville, FLBuilt 2011 · S/N 510-0344 N771KBLucky Stars LLC · Missoula, MTBuilt 2010 · S/N 510-0351 N771LJAmorada Leasing LLC · Fort Lauderdale, FLBuilt 2008 · S/N 510-0139 N774ARAlfa Romeo LLC · Anchorage, AKBuilt 2008 · S/N 510-0077 N774STN774st LLC · Leesburg, VABuilt 2009 · S/N 510-0245 N777BKNevada Restaurant Services Inc · North Las Vegas, NVBuilt 2008 · S/N 680-0247 N777CUJemk Services LLC · Mckinney, TXBuilt 2006 · S/N 680-0096 N777HNBank Of Utah Trustee · Salt Lake City, UTBuilt 2025 · S/N 680A0434 N777UTSho Deen Inc · Geneva, ILBuilt 2005 · S/N 680-0048 N778BCJ & H Equipment Leasing LLC · Santa Teresa, NMBuilt 2011 · S/N 510-0380 N778SCChandelle Investment Corp · Portland, ORBuilt 2016 · S/N 680A0029 N77TZSweetie Aviation LLC · Elmira, NYBuilt 2012 · S/N 510-0427 N77UWKeller Supply Co · Seattle, WABuilt 2019 · S/N 680A0233 N7876CMustang Aviation LLC · Wichita, KSBuilt 2009 · S/N 510-0229 N789MJEagle Union Quest One LLC · Philadelphia, PAFirst renewal noticeBuilt 2008 · S/N 680-0205 N789TSKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2012 · S/N 510-0395 N798LGJ&J Express Services LLC · Avenel, NJBuilt 2016 · S/N 680-0563 N799AJJamrock Leasing LLC · Schenectady, NYBuilt 2009 · S/N 510-0171 N799MJElk Mountains Capital LLC · Newark, DEBuilt 2013 · S/N 680-0511 N79BWilliam Becker LLC · Missoula, MTBuilt 2008 · S/N 680-0226 N79SGSteffes Group Inc · Fargo, NDBuilt 2007 · S/N 510-0043 N7EAEarnhardt Aviation LLC · Chandler, AZBuilt 2024 · S/N 680A0386 N7EDKwihnai Flyers LLC · Troy, OHBuilt 2009 · S/N 510-0210

Back to AD 2018-07-13