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.

N164DFStraighten Up Fly Right LLC · Oklahoma City, OKBuilt 1999 · S/N 24606 N164DJSchaefer Matthew J · Lawton, OKBuilt 2003 · S/N 21950 N164DPAviation Capital Management LLC · San Jose, CABuilt 1979 · S/N 28-8016190 N164DVLankston Robert R · Hernando, MSBuilt 2004 · S/N 90164 N164DZKoehn Don A · Arkdale, WIBuilt 1961 · S/N 28-242 N164ERSilver Express Co DBA · Miami, FLBuilt 1989 · S/N 2841180 N164EXDrj Management LLC · Weston, CTBuilt 2003 · S/N 164 N164GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881457 N164JDDominik James W · Golf, ILBuilt 1966 · S/N 18051816 N164JMWind Sand & Stars Aviation LLC · San Diego, CABuilt 1978 · S/N R18200158 N164JWBarry Edwin R · Apple Valley, CABuilt 2003 · S/N JW001 N164KDAnderson Cody James · Oroville, CABuilt 2005 · S/N 001 N164LAFive Star Marketing Inc · Morrisville, NCBuilt 2025 · S/N 371/US N164LEStraitgate Performance LLC · Mesa, AZBuilt 2001 · S/N 3164 N164LHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010063 N164LLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 32-714 N164LTErickson Steven L · Estherville, IABuilt 1993 · S/N 21633 N164MDehaan David J · San Diego, CABuilt 2010 · S/N TH-2295 N164MLJenkins Charles · Franklinton, LABuilt 1998 · S/N 60137 N164MSHose Louise D · Dayton, NVBuilt 1990 · S/N 20004 N164MTTaylor Michael S · Phoenix, AZBuilt 2006 · S/N 25589 N164NNewkirk Thomas R · Garland, NCBuilt 2002 · S/N 25564 N164PDKarimi Ashkan · Seattle, WABuilt 2003 · S/N 24705 N164PMChildress Michael W · Laporte, INBuilt 2019 · S/N 60274 N164RFFrenzel Robert P · Midlothian, TXBuilt 2010 · S/N 60255 N164RGGlass Roy L · Cardiff By The Sea, CABuilt 2005 · S/N 60266 N164RKAerinova Inc · Mattoon, ILBuilt 2006 · S/N 11467 N164RSCarter David C · Temple, TXBuilt 1995 · S/N 21168 N164SAOlson Helicopters LLC · Corpus Christi, TXBuilt 2006 · S/N 1559 N164SCCutler Scott D · Olympia, WABuilt 2007 · S/N 23763 N164SJFriedman Matthew · Herndon, VABuilt 1997 · S/N 18280064 N164SPClay David L · Bryceville, FLBuilt 1997 · S/N ML01 N164SUSouthern Utah University · Cedar City, UTBuilt 2024 · S/N 14713 N164SWNew England Aviation LLC · Plainville, CTBuilt 1975 · S/N 28-7690077 N164TMMacdowell John E · Kent, WAS/N 23524 N164ULariviere Jeffrey A · Douglassville, PABuilt 1967 · S/N 32-996 N164VGSchwartz David · Tualatin, ORBuilt 1998 · S/N 20438 N164WGBug Smasher LLC · Mitchell, SDBuilt 1990 · S/N 164 N164WMMcclellan Nicklas C · Mims, FLBuilt 2000 · S/N 22423 N164YFTwin Oaks Airpark Inc · Hillsboro, ORBuilt 1957 · S/N 23-1234 N16509Greensburg Jeannette Airport Administration · Jeannette, PABuilt 1973 · S/N 28-7305271 N1650CBrokaw Samuel J · South Bend, INBuilt 1953 · S/N 30350 N1650GWright Jeffrey Crandel · Opelika, ALBuilt 1968 · S/N 128 N1650JQureini Khalil H Vii · Kansas City, MOBuilt 1967 · S/N 28-24043 N1650UWilson Joshua Allen · Mckinney, TXBuilt 1974 · S/N 20700250 N1650ZRobinson Christopher C · Olivet, MIBuilt 1962 · S/N 185-0450 N16513Ashworth Diane A Executor · Chase City, VABuilt 1973 · S/N 28-7305273 N16518Dokter Garret H Jr Trustee · Big Bear Lake, CABuilt 1973 · S/N 28-7310102 N1651CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11755 N1651ENoffsinger Robert L · Winston Salem, NCS/N 17271081

Back to AD 2007-04-19 R1