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.

N1866SAviation Addiction LLC · Fishers, INBuilt 1998 · S/N 1866 N1867FIcarus Aviators LLC · Canon City, COBuilt 1966 · S/N 21058767 N1867HW Tech Consulting Inc · Kensington, MDBuilt 1977 · S/N 28-7715283 N1867XWaypoint208 LLC · Chubbuck, IDBuilt 1964 · S/N 18255967 N1868Barber Mark E · Shady Cove, ORBuilt 1973 · S/N 3 N1868GBrown Kirk W · Spring Branch, TXBuilt 1968 · S/N 109 N1868HSodah One LLC · San Ramon, CABuilt 1977 · S/N 28-7725165 N1868JCarlisle David · El Paso, TXBuilt 1968 · S/N 28-24309 N1868TShawley James C · Bolivar, MOBuilt 1971 · S/N 28-7225016 N1868VCreative Strategies Inc · Proctorville, OHBuilt 1974 · S/N 17263775 N1868WJohnson Brian D · Glidden, IABuilt 1973 · S/N E-436 N1868ZZulu Forty One LLC · Anchorage, AKBuilt 1962 · S/N 205-0068 N18694Hughes Randall L · Post Falls, IDBuilt 1976 · S/N 17702547 N18698Lumpkin Larry T · Ocala, FLBuilt 1969 · S/N 18052076 N1869FRegistration Pending · Dublin, OHRegistration pendingBuilt 1966 · S/N 21058769 N1869GMcdaniel Ronnie · Starkville, MSBuilt 1968 · S/N 189 N1869RHarwood John · Waxahachie, TXBuilt 1975 · S/N 28-7690060 N1869TMurray Bryan · Brighton, ILBuilt 1971 · S/N 28-7225018 N1869WWolter Kenneth W · Wasilla, AKBuilt 1969 · S/N 18-8835 N1869XFlying Yankees Inc · Nashua, NHBuilt 1964 · S/N 18255969 N1869ZPinnell Bradley T · Lake Havasu City, AZBuilt 1962 · S/N 205-0069 N186ACHartman James R Trustee · Everett, WABuilt 1994 · S/N 369-94 N186ASSmith Joel L · Cedar Park, TXS/N 738 N186AZIz Air LLC · Miami, FLBuilt 1976 · S/N 18503192 N186BPBearhawk Demo LLC · Fairview, OKBuilt 2019 · S/N P36-105P/106P N186CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13495 N186CSFlying Rock Aero LLC · Sunnyvale, CABuilt 2011 · S/N 172S11087 N186DMann Thomas A · Ford, WABuilt 1961 · S/N 185-0127 N186DFFine David E · Bigfork, MTS/N 1137 N186DTBell Michael · Cameron Park, CABuilt 2004 · S/N 18281442 N186FMJett Aviation LLC · Clovis, NMFirst renewal noticeBuilt 1977 · S/N 17269339 N186FSBuck Michael A · Spring Branch, TXBuilt 2000 · S/N 80760 N186GDelpier Michael J · Conroe, TXBuilt 2001 · S/N 60495 N186JHExecutive Transport Services LLC · Santaquin, UTS/N 1459 N186JPSogge Mark · Floyds Knobs, INBuilt 2004 · S/N 80730 N186KBAims Community College · Greeley, COBuilt 2018 · S/N 2881086 N186LUS Department Of The Interior · Boise, IDBuilt 2017 · S/N CC18-0086 N186MAMullins Robert · Dublin, TXBuilt 2012 · S/N 3160 N186MLIdaho Fly Girl LLC · Boise, IDBuilt 1974 · S/N U20602644 N186PDStarfighter Holdings LLC · Port Townsend, WABuilt 1999 · S/N 22096 N186QExecutive Bonanza Group · Sacramento, CABuilt 1964 · S/N D-7644 N186RABig T Aviation LLC · Wilmington, DEBuilt 2003 · S/N 1338-2002 N186RDWayson Air LLC · Mount Auburn, IABuilt 1966 · S/N 21058761 N186RLN186rl LLC · Fortson, GABuilt 1993 · S/N CE-1748 N186RMAdkins Robert P · Eagle River, AKBuilt 1958 · S/N 51603 N186RRGrenga Robert J · Gilbert, AZBuilt 1986 · S/N 943 N186RSSpears Jason · Milton, WVBuilt 2003 · S/N 80679 N186RVUvanni Bruce A · Shelburne, VTBuilt 2003 · S/N 60288 N186RZRex Zollinger Aviation LLC · Woods Cross, UTBuilt 1969 · S/N 18259557 N186SAClemente Motor Inc · Troy, NYBuilt 1999 · S/N 25025C

Back to AD 2007-04-19 R1