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.

N1448ZNational Training 1 LLC · Wilmington, DEBuilt 2005 · S/N 172S9891 N1449Registered aircraftBuilt 2007 · S/N 7086 N1449CAb Prop Plane I LLC · Metairie, LABuilt 2005 · S/N 172S9892 N1449EChase Matthew S · Rock Hill, SCBuilt 1978 · S/N 17271005 N1449GFayettenam Aero LLC · Laurinburg, NCS/N TC-248 N1449JAlpha Zulu Aviation LLC · Paragould, ARS/N 449 N1449UInternational Aviation Group LLC · Lake Wales, FLBuilt 1976 · S/N 17267116 N1449VLogsdon Timothy D · Livermore, CABuilt 1974 · S/N 17263586 N144AAllen Engineering · San Bernardino, CABuilt 1974 · S/N D-9633 N144AEMinard Stephan · Queen Creek, AZBuilt 2002 · S/N 40042 N144AFHelius Aircraft 144af LLC · Conroe, TXBuilt 2007 · S/N 1787 N144AHAtomic Helicopters LLC · Seattle, WABuilt 2001 · S/N 0865 N144AKExpress Helicopters LLC · Houston, TXBuilt 2004 · S/N 10226 N144AMStardust Aviation LLC · Farmingdale, NYBuilt 2021 · S/N 28020016 N144AXAngelone Inc · Elkhart, INBuilt 2007 · S/N 11827 N144AZBartosh Jason R · Big Pine Key, FLBuilt 1995 · S/N 21911 N144BCThomas George E · Rice, WAS/N 188 N144BFHyldburg Aviation Inc · Plymouth, MABuilt 1974 · S/N 17264101 N144BVSouthern Utah University · Cedar City, UTBuilt 2014 · S/N 13737 N144BWSkyward Leasing LLC · Kalispell, MTBuilt 2007 · S/N 12076 N144BZCrosswind Leasing LLC · Prescott, AZBuilt 2005 · S/N 10715 N144CCNightingale William T III · Rancho Cucamonga, CABuilt 1975 · S/N AA5B-84 N144CDLittle Gator Aviation Inc · Fairfield, NCBuilt 1999 · S/N 0602 N144CKClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13552 N144CLStewart Joseph W II · Eloy, AZBuilt 2006 · S/N 10980 N144CNGalliot Bond LLC · Atlanta, GAS/N 27-8054036 N144CPHobgood Mitch D · Tylertown, MSBuilt 2024 · S/N 20420 N144DRandall John R · Pearl River, LABuilt 1978 · S/N 18053001 N144DFPessel William O Jr · Princeton, NJBuilt 1993 · S/N 1907 N144DGSiktberg Timothy J · Nashville, TNBuilt 1999 · S/N LIV-144-P N144DHSky 1 Inc · Wilmington, DEBuilt 1996 · S/N 1219-96 N144DJSaybrook Offshore LLC · Guilford, CTBuilt 2017 · S/N 2467 N144DMExecutive Helicopters Inc · Myrtle Beach, SCBuilt 2003 · S/N 10044 N144DRSchneider Robert Keith · Bolivar, TNS/N 23587 N144DSStevenson William E · Sutton, AKBuilt 2000 · S/N 0715 N144DVAnderson Darrell L · Great Falls, MTBuilt 2016 · S/N 2850 N144DZAurora Helicopters LLC · Lansing, ILBuilt 2003 · S/N 10100 N144EHScout Aviation LLC · Odessa, TXBuilt 2005 · S/N 10742 N144ESSpain Heliventures LLC · Wilmington, DEBuilt 2003 · S/N 10228 N144EZFlorida Aviation LLC · Tallahassee, FLS/N 32R-7885184 N144FFoster Gary E · Kress, TXBuilt 1963 · S/N D-7142 N144FLSouth Florida Helicopters Inc · Indiantown, FLS/N 0654 N144GDRandall B Langley Licensed Real Estate Broker LLC · Longboat Key, FLS/N 12706 N144GGAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2018 · S/N 14212 N144GHTrack Up Trading Corp · Cheyenne, WYBuilt 2007 · S/N 12077 N144GMWilliams David · Golden, MOBuilt 1962 · S/N D-7010 N144HRRsa Aviation Enterprises LLC · Peachtree City, GABuilt 2005 · S/N 153 N144JCJackson Construction Aviation LLC · Quitman, TXBuilt 1977 · S/N 340A0360 N144JGMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2000 · S/N 0859 N144JHTrachtenberg Dennis J · San Diego, CAS/N 31059

Back to AD 2007-04-19 R1