Registered aircraft · 108,433

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.

N21585Ck Leasing Services LLC · Wilmington, DES/N 17263978 N21587B & D Fuel Injection Service Inc · Rhoadesville, VABuilt 1973 · S/N 18261733 N21588Jackson Hole Airport Board · Jackson, WYBuilt 1974 · S/N 17263979 N2158AHowlett Corey W · Wasilla, AKBuilt 1953 · S/N 18-1873 N2158FCampbell Barrett Hunter · San Antonio, TXBuilt 1978 · S/N 32-7940005 N2158JMccormick Eugene C DBA · Tyler, ALBuilt 1979 · S/N T18803395T N2158N2th Aviation LLC · Johnson City, TNBuilt 1998 · S/N 29-0167 N2158SChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9539 N2158ZTribute Aero LLC · Rochester, MIBuilt 1979 · S/N 28-7990403 N21591Kohn Aviation LLC · San Carlos, CABuilt 2004 · S/N 172S9658 N21593Peyt Rentals LLC · Cobb, GABuilt 1973 · S/N 18261739 N21597Gsw Flyers LLC · Pittstown, NJBuilt 1973 · S/N 18261741 N21598Kcsi Aerial Patrol Inc · Bakersfield, CABuilt 1973 · S/N 18261742 N2159ER & S Investment Partners LLC · Kennesaw, GABuilt 2000 · S/N 29-0238 N2159GKirchoff Kevin B · Millington, TNS/N 51459 N2159HBeverly Flight Center LLC · Middleton, MABuilt 1978 · S/N 28-7916192 N2159LMark A Smith Airplane Sales Inc · Homosassa, FLBuilt 1976 · S/N E-902 N2159QWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1979 · S/N 28-7916282 N215AMurphy Dan A · Two Harbors, MNBuilt 1954 · S/N 35013 N215AFArmed Forces Aero Club · San Diego, CABuilt 1978 · S/N 17270844 N215AVNational Test Pilot School · Mojave, CABuilt 2002 · S/N GA8-02-015 N215BCMetzler Alan J · Reedsville, PABuilt 2005 · S/N 468-2005 N215BFWiederhoeft Dustin L · Fairmont, MNBuilt 1964 · S/N D-7665 N215CTahome LLC · Saint Petersburg, FLS/N 32501 N215CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13074 N215CBKw Bradley Associates LLC · Manlius, NYBuilt 1980 · S/N 340A1019 N215CDValiair Lc Trustee · Casper, WYBuilt 2001 · S/N 1114 N215CFHarter Ryan · Greenfield, INBuilt 2000 · S/N 24722 N215CHKld Air LLC · Charlotte, NCBuilt 1977 · S/N TE-1116 N215CSStein Curt · New Ringgold, PABuilt 2021 · S/N PX1520014 N215DBHurst Jeffrey A Trustee · Tahoe City, CABuilt 1980 · S/N R18201641 N215DCSpitzer Helicopter LLC · Woodland Hills, CABuilt 2012 · S/N 13291 N215DJGreat Plains Aviation LLC · Scott City, KSBuilt 2005 · S/N 18281622 N215DWMoore David R · Granbury, TXBuilt 2012 · S/N 40455 N215ERAmerican Capacitor Corp · Irwindale, CABuilt 1992 · S/N 10117 N215FRJjg Aviation LLC · Miami, FLBuilt 1978 · S/N 17271822 N215GNBbt Jewelry LLC · Miami, FLS/N P21000335 N215GRDesilva David I · Carolina, PRBuilt 2000 · S/N RV8-80573 N215GSFlight Equity LLC · Fayetteville, ARBuilt 2022 · S/N 14528 N215GTInsulation By Cohens LLC · Moncks Corner, SCS/N TH-2439 N215HGGazzaz Hussein · Lakeway, TXBuilt 2025 · S/N 18283328 N215HRLld Inc · Sarasota, FLBuilt 2003 · S/N 172S9527 N215JInnovative Aerodynamic Technologies · Yorktown, VAS/N 21059226 N215JCCavanaugh Air LLC · Addison, TXBuilt 1984 · S/N 21546 N215LLNorthern Colorado Capital Holdings LLC · Timnath, COBuilt 2010 · S/N LS227 N215LPChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9215 N215MSMulcaire Jess E · Camp Verde, AZBuilt 1988 · S/N S1313 N215NCDodson International Parts Inc · Rantoul, KSBuilt 2002 · S/N E-3444 N215PDube William E Jr · Prescott, AZBuilt 1992 · S/N CE-1676 N215QSooter Craig A · Sedgwick, KSS/N D-7600

Back to AD 2007-04-19 R1