Skip to content

Registered aircraft · 959

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:2016-19-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:2016-19-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:2016-19-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:2016-19-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:2016-19-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:2016-19-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.

N1VMChildress Klein Management Services LLC · Charlotte, NCBuilt 2012 · S/N 240 N2000LMl Fare LLC · Newark, DEBuilt 1999 · S/N 109 N2000RN37hk LLC · Fayetteville, ARBuilt 2006 · S/N 85 N200CHAllegiance I LLC · Columbus, OHBuilt 2015 · S/N 319 N200CRRomana Aircraft Inc · High Point, NCBuilt 2007 · S/N 133 N200GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 336 N200JM200jm LLC · Glendale, AZBuilt 2025 · S/N 431 N200JWN200jw LLC · Woodburn, ORBuilt 2000 · S/N 128 N200LXBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 337 N200MVRiverside Consulting LLC · Salem, ORBuilt 2011 · S/N 229 N200WLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 352 N201WRDelaware Park LLC · Wilmington, DEFirst renewal noticeBuilt 2002 · S/N 201 N202WRDumont Associates Inc · Morris Plains, NJBuilt 1987 · S/N 24 N203AFAir4 Aviation LLC · Houston, TXBuilt 1994 · S/N 003 N203NCC Aviation LLC · Maiden, NCBuilt 1990 · S/N 203 N206FJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 206 N209CQFalcon 900ex Msn 98 LLC · New Castle, DEBuilt 2001 · S/N 98 N20GPN83 Charlie Inc · Fort Wayne, INBuilt 1992 · S/N 113 N20TTuthill Corp · Burr Ridge, ILBuilt 2011 · S/N 228 N211WGPentair LLC · Palmetto, FLBuilt 2006 · S/N 142 N214DVRk-492 Leasing LLC · Miami, FLBuilt 2007 · S/N 350 N214FTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 300 N214LDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 41 N214TFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 348 N215FHWade Aviation LLC · Newark, DEBuilt 2004 · S/N 030 N215RECompton Kincaid LLC · Wilmington, DEBuilt 2004 · S/N 215 N21HMIheartmedia Management Services Inc · New York, NYBuilt 1988 · S/N 41 N21JTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 112 N220DFFalcon Aviation Z LLC · Great Neck, NYBuilt 1998 · S/N 69 N221CBFalcon 50ex 320 LLC · Miami Gardens, FLBuilt 2001 · S/N 320 N222JEHigher Cause LLC · Byron Center, MIBuilt 2008 · S/N 173 N222JSFliteaccess LLC · Louisville, KYBuilt 2005 · S/N 75 N222MSStavola Aviation Inc · Anthony, FLBuilt 2008 · S/N 177 N223FJPacific Dental Services LLC · Irvine, CABuilt 2011 · S/N 223 N224NCCollier Companies Aviation LLC · Gainesville, FLS/N 42 N225GLRunway Rouge LLC · Baton Rouge, LABuilt 2006 · S/N 608 N22NFSunwest Aero LLC · Dallas, TXBuilt 2007 · S/N 114 N22TSDevco Properties II LLC · Louisville, KYBuilt 2002 · S/N 179 N232EZCrest Operations LLC · Pineville, LAS/N 232 N232RJRj Aircraft Leasing LLC · Fargo, NDBuilt 2000 · S/N 130 N233EHWexford Wells Aviation LLC · Greensboro, NCBuilt 2002 · S/N 144 N233KCMp Air LLC · Eagle Point, ORBuilt 1998 · S/N 48 N234FJAlfonso Media Logistics LLC · Miami, FLBuilt 1996 · S/N 34 N236LXWilmington Trust Co Trustee · Delaware, DEBuilt 2011 · S/N 236 N237BBBaron & Budd P C · Dallas, TXBuilt 2006 · S/N 70 N239AXAviation8 LLC · Carle Place, NYBuilt 1987 · S/N 39 N23BEBenjamin Partners LLC · Wilmington, DEBuilt 2006 · S/N 78 N23FMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 296 N23SMSam & Sam3 Consulting LLC · Scottsdale, AZBuilt 2011 · S/N 227 N243CF2bar Aviation LLC · Denver, COBuilt 2011 · S/N 243

Back to AD 2016-19-13