Registered aircraft · 108,428

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

N110MFHunter Gregory G · Seattle, WABuilt 2001 · S/N 0010 N110MRKertz Ryan E · Sonoma, CABuilt 1988 · S/N HL10 N110MSMcaleer Scott · Scranton, IABuilt 1969 · S/N 28R-35194 N110NJState Of New Jersey · Trenton, NJBuilt 1986 · S/N U20606938 N110PSHartvigsen Thomas E · Winchester, TNBuilt 1996 · S/N 5335 N110RRiggins James · Monument, COBuilt 2002 · S/N 95-001JR N110RJMathias Ralph · Long Beach, CAS/N 17272173 N110RMColeman Charles T · Ludington, MIBuilt 1980 · S/N HL-11 N110SCClark Steven D · Bloomfield, INBuilt 2013 · S/N 40254 N110SGTaylor John III · Suwanee, GABuilt 2001 · S/N 458-2001 N110SQLand Air & Sea LLC · Concord, NCBuilt 2006 · S/N 172S10384 N110SUAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-81 N110SXSkyryse Inc · El Segundo, CABuilt 2008 · S/N 12328 N110TSeymour Lori L · Woodstock, GAS/N 342-H N110TFRegistered aircraftBuilt 1977 · S/N 24-0095 N110TKSchnorf Curt L · Centerview, MOS/N 18262939 N110TNMaloney Casey · Placerville, CABuilt 1972 · S/N 28-7305054 N110UDarnell Charlie · Eads, TNS/N 595 N110USZwainz Thomas G · Reardan, WABuilt 1970 · S/N 18260234 N110UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1216 N110VEHorizon Group Inc Trustee · Boca Raton, FLBuilt 1977 · S/N 414A-0017 N110VPFly Aviation Corp · Wilmington, DEBuilt 1977 · S/N 28-7716189 N110WRRuffo-Silva LLC · Wilmington, DEBuilt 1978 · S/N 32R-7985056 N110WTW T Aviation LLC · Wichita, KSBuilt 1989 · S/N 3206050 N110WWTorba Jacob · Citrus Heights, CABuilt 1969 · S/N 30-1846 N110XPGreenstreet Scott · Poplar Grove, ILBuilt 2007 · S/N 40433 N110YDLloyd Clee · Canby, ORBuilt 1975 · S/N 21060858 N11103Hennigan Shellie · Jonesboro, LAS/N 17702325 N1110CGriffith Danny E · Little Rock, ARS/N D-5117 N1110ERegistration Pending · Hanford, CARegistration pendingBuilt 1977 · S/N 302-77 N1110FSallade William L · Coudersport, PABuilt 1966 · S/N 17254705 N1110SMob Aviation USA LLC · Kissimmee, FLS/N 21061119 N1110WFoulks Alan Lee Trustee · Glendale, AZBuilt 1972 · S/N D-9310 N11114Daly Arthur P · El Paso, TXBuilt 1968 · S/N D-8901 N11115Crist Steve · Reno, NVS/N 17262410 N11118Aircraft Partner Holdings Inc Trustee · Fallbrook, CABuilt 1963 · S/N 18051230 N1111EDory Joe · Austin, NVBuilt 2012 · S/N 471C N1111HBielamowicz John Kolbe · Waxahachie, TXBuilt 1964 · S/N 30-427 N1111KBlue Monkey Disposing & Recycling Inc · Tampa, FLBuilt 1983 · S/N 60-8365021 N1111LShepard Logan K · Sultan, WABuilt 1983 · S/N 277 N1111ZHamburger Ronald O · Terrebonne, ORBuilt 1960 · S/N CD-276 N1112JJedco Properties LLC · Ruston, LABuilt 1997 · S/N TH-1822 N1112QLastowski Gerald J · Gulf Breeze, FLBuilt 1963 · S/N 310H0112 N1112TRegistration Pending · Soldotna, AKRegistration pendingBuilt 1964 · S/N 50713 N1112XArrow Flyers LLC · Englewood, COS/N 28R-7535247 N11131Gaglioti John · Monterey, CABuilt 1983 · S/N R18201942 N11132Triple One 32 LLC · Sergeant Bluff, IABuilt 1995 · S/N 2890230 N1113NSkywagon Aero LLC · Wilmington, DEBuilt 1975 · S/N 18-7509033 N1113TWirthlin Donald K · Sierra Vista, AZBuilt 1957 · S/N 35561 N1113ULeft Base Aviation LLC · Niagara, WIBuilt 1989 · S/N 2890126

Back to AD 2007-04-19 R1